下一步,创建伪事实查询主题与所需维度的连接。
Next, create joins from the fake fact query subject to the required dimensions.
销售事实查询主题的事实数据一旦加入报表,连接关系就会对销售事实表而不是伪事实起作用,就会返回需要的数据。
As soon as fact data from the sales fact query subject is added to the report, the join relationship goes through the sales fact table rather than the fake fact, and the data returns as expected.
伪事实表将会用在连接中代替实际的事实表,从而提升单独从维度查询的响应时间。
The fake fact table will be used in the joins instead of the actual fact table, thereby improving response times when querying solely from the dimensions.
应用推荐