维度订单会影响计算性能
确保在维度顺序上保持一致性将有助于提高模型的性能。这种一致性与模块和单个订单项有关。为什么订单很重要？Anaplan创建并使用索引来执行计算。尺寸相交的模块中的每个单元格都会给出一个索引号。
Here are two simple modules dimensioned by Customer and Product. In the first module, Product comes first and Customer second, and in the second module, Customer is first and Product is second.
在此模型中，有一个第三个模块将收入计算为价格 *量。
Anaplan将索引分配给模块中的交叉点。这是两个模块的索引值。请注意，某些交叉点对模块的索引相同：客户1和产品1，Customer 2和Product 2，以及客户3和产品3，其余的单元格具有不同的索引编号。客户1和产品2在顶部模块中的值为4，底部模块中的值为2。
The calculation is Revenue = Price * Volume.
为了运行计算，Anaplan通过匹配两个模块的索引值来执行以下操作。
由于索引值未对齐，因此处理器在执行计算之前会扫描索引值以找到匹配项。
When the dimensions in the module are reordered, these are the index values:
现在对每个模块的索引值进行对齐。由于相同维度结构的线条项目具有相同的布局，因此数据在内存中线性布置。计算过程以完全线性且可预测的方式访问内存。Anaplan的微处理器和内存子系统经过优化，以识别这种访问模式，并预先获取所需的数据。
How does the dimension order become different between modules? When you build a module, Anaplan uses the order that you drag the lists onto the Create Module dialog. The order is also dependent on where the lists are added. The lists that you add to the 'pages' area are first, then the lists that you add to the 'rows' area, and finally the lists added to the 'columns' area.
重新排序列表并确保一致性很容易。按着这些次序：
- On the Modules pane, (Model Settings>Modules) look for lists that are out of order in the Applies To column. Click the Applies To row that you want to re-order, then click the ellipsis.
- 在“选择列表”对话框中，单击“确定”。
- 在确认对话框中，单击“确定”。
- The lists will be in the order that they appear in General Lists.
- 完成检查模块中的列表订单后，单击“订单”选项卡并检查订单项。按照步骤1到3进行重新排序列表。
子集和订单项子集
One word of caution about Subsets and Line Item subsets. In the example below, we have added a subset and a Line Item Subset to the module:
The Applies To is as follows:
Clicking on the ellipsis, the dimensions are re-ordered to:
The general lists are listed in order first, followed by subsets and then line item subsets.
您仍然可以双击适用于列，并按照正确的顺序复制或键入尺寸来重新排序尺寸。
最小与最小？
This is the normal follow up question, and unfortunately, the answer is "it depends." Through research we have found that it all depends on the data within the module. Also, it can get very confusing if subsets are used; the Customer list might be bigger than the Products list, but if a subset of Customers is used that is smaller than Products, then what?
另外,我们不提倡秩序在g the lists in the General Lists setting in size order; the lists should be ordered in hierarchical order top to bottom, so, by definition, that will be smallest to largest. So our advice is be持续的. Think about how you describe the problem. Does the business talk about Customer by Product, or Products for Customers? Agree to a convention, and stick to it.
其他维度
计算性能仅与common源和目标之间的列表。一个或另一个单独列表的顺序与计算速度无关。
