2.02-03 No Repeated expressions

rob_marshall
rob_marshall
in Planual

If the expression is repeated in the formula (or other modules), put it on a separate line item.  “Calculate once, reference many times”

Tagged:

Comments

  • Misbah
    Misbah

    Rule 2.02-03 No Repeated Expressions. If the expression is repeated in the formula (or other modules), put it on a separate line item. Calculate once, reference many times. It goes against PERFORMANCE, AUDITABLE, NECESSARY elements of PLANS if you wish to go against this rule

    Here is how it was done in Pre Planual Era:

    Misbah_0-1590512366819.png

    What is wrong with this method? Same thing is getting calculated four times at four different places. It surely adds work for the engine and it is absolutely unnecessary to get it done this way

    Here is how it should be done in Planual Way:

    Misbah_1-1590512366838.png

    Note: Condition Line item can be placed in a SYS Time module and shouldn’t be placed in the multidimensional module. The above snip is only for demonstration purposes

Title

Categories