2.01-11 Keep the Dimension Order consistent

Ensure the dimension order is consistent among modules. Calculations are faster if the common dimensions are in the same order as the Applies To.  The size of the list is not as critical as the order

 

Best Practices article:
Dimension Order

0 Kudos
Comments

Rule 2.01-11 Keep the Dimension Order consistent. Ensure the dimension order is consistent between modules. Calculations are faster if the common dimensions are in the same order in the “Applies to” section.  The size of the list is not as critical as the order. It goes against PERFORMANCE & LOGICAL elements of PLANS if you wish to ignore the dimension ordering

Here is how it was done in Pre Planual Era: There was no proper care and due diligence taken when considering the order of the dimensions in the module. For example, to calculate Revenue we multiply Volumes with Prices.

Data Volume Module – Dimensioned by Products & Customers. Products at first position and Customers at second position

Misbah_0-1589804674306.png

Data Price Module - Dimensioned by Products & Customers. Customers at first position and Products at second position

Misbah_1-1589804674316.png

What is wrong with this method? Anaplan assigns indexes to the intersections in the module. Here are the index values for the two modules. Note that some of the intersections are indexed the same for both modules: Customer 1 and Product 1, Customer 2 and Product 2, and Customer 3 and Product 3 but  the remaining intersection of cells have different index number. Customer 1 and Product 2 is indexed with the value of 4 in the top module and the value of 2 in the bottom module.

Misbah_0-1601534996826.png

The calculation is Revenue = Price * Volume.

To run the calculation, Anaplan performs the following operations by matching the index values from the two modules.

Misbah_3-1589804674338.jpeg

Since the index values are not aligned, the processor scans the index values to find a match before performing the calculation. Hence impacting performance of the model

Here is how it should be done in Planual Way: Re-order your dimensions to keep it consistent across all modules. Either Product Customer or Customer Product configuration, as long as you keep it in the same order, performance will be greatly improved.

As soon as you re-order Index values for each of the modules will be aligned. As the line-items of the same dimensional structure have an identical layout, the data is laid out linearly in memory. The calculation process accesses memory in a completely linear and predictable way. Anaplan’s microprocessors and memory sub-systems are optimized to recognize this pattern of access and to pre-emptively fetch the required data.

Misbah_4-1589804674348.jpeg

 How to Re-order the Dimensions: It’s pretty simple to re-order the dimensions and ensure consistency. Learn more  Dimension Order - Anaplan Community