请注意,该数字涉及到结果的潜在大小,这是通过将每个维度上包含的所有成员乘以其他维度的所有成员计算得出的。
Please note that this number relates to the potential size of the result which is calculated by multiplying all included members from each dimension by all members of the other dimensions.
由于每个维度表过滤的选择度,每次连接都会减少事实表大小的十分之一。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
如果需要对产品大小进行汇总收入,那么可能需要更改模型,用模型中的一个物理维度来替换此属性。
If the revenue is required to roll up for the product size, the model may need to be changed to include replace the attribute with a physical dimension within the model.
应用推荐