允许和拒绝的成员组必须是 MDX 表达式,表达式的计算结果为该维度的成员组。
The sets of allowed and denied members must be MDX expressions that evaluate to sets of members of the dimension.
在这两种情况下,考虑在伪事实表的连接表达式中添加额外的逻辑,这会缩小从维度表返回的连接键值的范围。
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
由于伪事实的每个维度中的连接表达式的过滤,笛卡尔连接结果缩小了。
The Cartesian join is reduced by the filters found in the join expressions from each dimension to the fake fact.
应用推荐