Planual Explained - Day 31
"Rule 1.01-04": Article 1, Chapter 1, and Rule 4” 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
Answers
-
TIMESUM is a killer, as @rob_marshall has reminded me at least six times. Never hurts to hear it again, especially if that function can be avoided.
0
