TM1 Rules Functions -- New Resource!
Did you know that Cubewise just published definitions for all the IBM Planning Analytics TM1 Rules functions, with examples and syntax explanations? Each video shows the rule function in action, so you can see a clear example, which is pretty neat.
You can find videos for 100+ TM1 rules functions on our YouTube channel, here:
https://www.youtube.com/watch?v=Tsk4wKeGkS8&list=PLSKJHVkaW8CatV0mjD6PS15sDfhbVK2iw
Here are a couple of my favorite Rules functions, with the links to the video for each!
CONTINUE
This is a powerful command that can really simplify complex “if” statements. I frequently use “CONTINUE” as the “else” portion of the “if” statement. It allows you to split up a complex rule into multiple simple rules, instead.
https://www.youtube.com/watch?v=k9wH_meMrGY
ELISANC
This function determines if one element is the ancestor of another element. It’s very useful for applying rules to one set of elements, such as all the Overhead departments, or all the Travel related expense accounts.
https://www.youtube.com/watch?v=DGJ6QH1Jcew
CONSOLIDATECHILDREN
This function forces TM1 to consolidate the children of a particular roll-up. It can be useful when you have a mix of N and C rules, and TM1 is not consolidating along the appropriate hierarchy. For example, headcount should add across the departments, but not the months.
Senior Sales Expert - Driving Business Growth
4 年Great Robin thanks for putting this out there, a great new resource for TM1 Rules Functions!