Planual Explained - Day 38

Misbah
Misbah
in Modeling

"Rule 1.06-03": Article 1, Chapter 6, and Rule 3” Avoid single item subsets If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members

Here is how it was done in Pre Planual Era. We used to create a subset which includes/houses just a single list item

List:

Misbah_0-1599643661762.png

Input module:

Misbah_1-1599643666680.png

Output module:

Misbah_2-1599643674400.png

What is wrong with this method? Item which was supposed to be just one has become two because it will have top level coming along with it.

Here is how it should be done in Planual Way: Can be done in many ways. One way could be with the help of LOOKUP module. Get rid of the subset as a dimension and use LOOKUP on the ssAsia or Region formatted line item

Output Module

Misbah_3-1599643705299.png

LOOKUP module:

Misbah_4-1599643712358.png

Misbah_5-1599643718289.png

 

Tagged:

Categories