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: 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…
May 7, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Calculations
Did you know IBM Planning Analytics offers more than one way to add calculations to your data? The great thing about using Planning Analytics within Excel is that you can add additional calculations to your data set to help you further analyze…
April 30, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Cell Comments
Did you know IBM Planning Analytics Workspace allows you to add comments to your data set? During both planning and reporting cycles, many clients often ask how they can add comments into their data set. After all, the goal of a Planning…
April 23, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Tracing Calculations in Planning Analytics Workspace
Did you know that you can trace the details of a calculation in an IBM Planning Analytics Workspace exploration? The following screen shot shows a simple revenue calculation that uses input values for Units and Unit Price. You can right click on…