reportstudio中交叉（元组） 中的 交叉层级 的具体作用？

xiaoerp

请问一下reportstudio中交叉（元组） 中的 交叉层级 具体作用是什么？请大虾们解释一下。谢谢了

该贴已经同步到 xiaoerp的微博

xiaoerp

Assigning a Hierarchy or Dimension
You must assign each calculated member, set expression, and intersection (tuple) to a hierarchy or
dimension. We recommend that you select the hierarchy or dimension upon which your calculation
focuses. For example, if your calculated member is based on years, select the Time hierarchy. If you
create a calculated measure, select the Measures dimension.
Select only a hierarchy that cannot affect the value of the calculation. For example, the hierarchy
Camping Equipment has the same value no matter what Products context it appears in the report.
Therefore,
● the calculation ([Camping Equipment]-[Mountaineering Equipment]) has a well-defined
meaning only in the Products hierarchy, so select that hierarchy.
● the calculation tuple ([Revenue], [Camping Equipment]) can be assigned to either the Products
or Measures hierarchy, as it is not affected by either context.
● the calculations ([1999] - [Camping Equipment]) and ([Fiscal Year 1999] - [Calendar Year
1999]) do not have a well-defined meaning in any hierarchy, and therefore cannot be used
reliably at all.


分配层级或维度
必须将每个计算的成员、集合表达式和交集（数组）分配到一个层级或维度。我们建议您选择计
算关注的层级或维度。例如，如果计算的成员是基于年份，请选择“时间”层级。如果要创建计
算的度量，请选择“度量”维度。
请仅选择不会影响计算值的层级。例如，不管报表中显示什么“产品”上下文中，“露营装备”
层级的值都保持不变。因此，
● 计算([露营装备]-[登山装备]) 仅在“产品”层级中有明确意义，所以应该选择该层级。
● 计算数组([收入], [露营装]) 可分配给“产品”或“度量”层级，因为“产品”或“度量”
上下文对它都没有影响。
● 计算([1999] - [露营装备]) 和([财政年度1999] - [日历年度1999]) 在任何层级中均
无明确意义，因此不能作为可靠的计算使用。