1.01-04 Consider All Periods

rob_marshall

Consider the use of All Periods.  This is effectively the Top Level for time and whilst increasing the model cell count very slightly it does allow for flexibility in modelling.  This is especially useful if you need to reference the same calculation many times

Misbah

Rule 1.01-04 Consider All Periods. Consider the use of All Periods.  This is effectively the Top Level for time and whilst increasing the model cell count very slightly it does allow for flexibility in modelling. . It goes against PERFORMANCE elements of PLANS if you wish to go against this rule

Use Case: Ability to see the lifetime Sales for each Region

Here is how it was done in Pre Planual Era. We used to use TIMESUM to aggregate the values from a module dimensioned by Time to a module which is without Time dimension.

Source Module:

Target Module:

What is wrong with this method? TIMESUM is a single threaded function and takes a heavy toll on performance. Hence should be avoided as much as possible

Here is how it should be done in Planual Way:

Go to Time Page of your model and activate the “Total of All Periods” Option. It does increase the cell count marginally but it gives you the performance benefits in return.

Use Select Function on All Periods and pull the values