IBM Planning Analytics Tips & Tricks
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…
May 21, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Snap Commands – Sorting
Did you know IBM Planning Analytics has snap commands that allow you to use natural language wording to perform simple tasks? One example of this entails the use of sorting data within a view. We can start with a simple view that…
May 14, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Template Styles
Many of you know that Planning Analytics Workspace books allow you utilize templates, but did you know there is a difference between the options that show a solid frame vs. the options that show a dotted frame? Creating a new PAW book…