Exploring TM1 - a Chartertech Company
Search
Close this search box.

Limiting a Rule to Active Scenarios Only

Today I wanted to update a rule so that the processing of the rule was limited only to those scenarios that are “active”.  I could have gone through each line in the rules and added specific references to the scenarios I want to be active in the scope of each line of the rules. What I wanted was to limit rules to work only on specific scenarios.

I then thought of this. If in my Scenario dimension I have a parent called “Active Scenarios” and then have the scenarios “Current Budget” and “Current Scenario” as child to that, then I could insert a rule right at the top of my rules that says:

# Limit the rules to only those scenarios that are children of Active Scenarios in the Scenario dimension

[] = IF ( ELISANC ('Scenario', 'Active Scenarios', !Scenario) <> 1, STET, CONTINUE) ;

And bingo, only those children of ‘Active Scenarios’ will use the rules that follow.

I specifically wanted this in place as we then want to create a TI process that allows us to copy the contents of a scenario as a static archive to a new scenario.  For example, copy “Current Budget” to “Budget Submission 1”.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In