IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: IFERROR
Did you know one of the great things about creating TM1 Web sheets is that you simply need to create an Excel sheet and then press a button called Publish? This will convert your Planning Analytics formulas into a web-based interface that…
July 30, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Rule Concepts that are often Forgotten
Did you know that rules are used in TM1 to perform live calculations without the need for any manual intervention or on-demand scripts? This is a very powerful aspect of Planning Analytics and, when used properly, increase the value of the tool…
July 23, 2019
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…