Planual Explained - Day 33

Misbah
Misbah
in Modeling

"Rule 1.02-01": Article 1, Chapter 2, and Rule 1” Use Current Version setting Utilizing the Current Version (and Actual Version) within the Version Settings allows the use of CURRENTVERSION() and ACTUALVERSION() for use in calculations and SELECT statements and  ISCURRENTVERSION and ISACTUALVERSION() for Boolean checks

Use Case: To populate the current version numbers (Forecast) in your target module

Here is how it was done in Pre Planual Era.

Source Module having data in multiple versions

Misbah_3-1599470341201.png

Misbah_2-1599470320591.png

What is wrong with this method? We don’t need to write SELECT statement in such cases. We can avoid system doing that extra work to pull the numbers

Here is how it should be done in Planual Way: Go to Versions and mark Forecast Version as Current Version

Misbah_4-1599470366945.png

Simply refer the line item from Source Module

Misbah_5-1599470372730.png

Note: There are other benefits of using Current Version settings in your model such as the usage of CURRENTVERSION() and ISCURRENTVERSION

Tagged:

Answers

  • JaredDolich
    JaredDolich

    @Misbah 

    Yes, sir! For those using versions this is a must. Only complaint I have about this one is that the current version has to be manually set by a WA.

Categories