IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Manipulate Case Used for Text
Did you know IBM Planning Analytics rules can be used to manipulate the case used for text? There are rules to change values into both uppercase and lowercase. UPPER Converts an entire string to upper case UPPER(‘Lee Lazarow wrote this’) becomes LEE…
July 16, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Ways to Stop a TI Process
Did you know there are two different ways to stop a TurboIntegrator script? The ProcessBreak command stops processing source data and proceeds directly to the Epilog. This approach allows you still run code in the Epilog that can perform tasks such as…
July 9, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Ways to Skip a Record Using a TI Process
Did you know there are two different ways to skip specific records when you are running TurboIntegrator scripts? ItemSkip is used to skip a specific record. This is often nested within an IF statement and used when you want to simply ignore…
July 2, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Best Practices for Hierarchies
Did you know IBM Planning Analytics hierarchies are used to see alternative data rollups in the same view? By default, all dimensions include a single hierarchy based on the original definition. Creating multiple hierarchies in a dimension is initially disabled in Planning…
June 25, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Maintain a Hierarchy via a TurboIntegrator Process
Did you know it is best practice to maintain a hierarchy in Planning Analytics via TurboIntegrator (TI) process whenever possible? There are five key functions that can be used to do so. HierarchyExists(DimName, HierName) HierarchyExists is used to determine whether a specific…
June 18, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel
Did you know there are some easy approaches to troubleshooting IBM Planning Analytics for Excel (PAx)? Given that PAx is an Excel add-in, sometimes things go wrong. Do you know the basic steps to take when a user says that PAx isn’t…
June 11, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Planning Analytics Workspace Rule Editor, Part 2
This is a guest post from Shane Bethea. Did you know there are new features in the IBM Planning Analytics Workspace (PAW) Rule editor that were not in the TM1 Rule editor? Even if you are familiar with writing rules in TM1,…
June 4, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Planning Analytics Workspace Rule Editor, Part 1
This is a guest post from Shane Bethea. Did you know that most TM1/Planning Analytics development can now be done in Planning Analytics Workspace (PAW)? PAW has a lot of development capabilities and allows modelers to do most development that would have…
May 28, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Snap Commands – Spelling
Did you know IBM Planning Analytics' snap commands can serve as a spellcheck for you? In today’s Twitter and text based world, misspellings (or abbreviations, as some people call them) have become a way of life. It’s virtually impossible to make it…