Planual Explained - Day 36

Misbah
Misbah
in Modeling

"Rule 1.05-07": Article 1, Chapter 5, and Rule 7” Avoid Top Level for large flat lists If you need the totals, look to add dummy parents to make the calculations more efficient

Here is how it was done in Pre Planual Era. Lists that need to be aggregated we used to have a top level for all these lists irrespective of the size of the lists. Below list just contains over a million transactions (For the understanding purpose).

Misbah_0-1599545402646.png

What is wrong with this method? In order to understand look at the screenshots below. It is based on the idea called Selective Aggregation which is Anaplan will recalculate blocks of data in order to calculate a parent block.

Misbah_1-1599545411835.png

If Toronto were to change, all other cities would need to be calculated in order to recalculate the “All Cities” top level. If there were no top level, this recalculation would not need to occur. However, the more levels we add to the hierarchy, the less calculations need to occur.

Misbah_2-1599545418666.png

Here is how it should be done in Planual Way: Split the large lists and add dummy parents in it. In the earlier lists containing more than a million transactions I added 5 dummy parents.

Misbah_3-1599545424693.png

Misbah_4-1599545429968.png

Note: The process of addition of dummy parents can happen within Anaplan or outside Anaplan. I would say it should come from the source system or the ETL layer needs to split this large list into multiples (If the list is being dynamically updated). Also once the list is loaded with dummy parents it should always be delta load after that.

Tagged:

Answers

Categories