IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel SEQUENCE
Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…
November 22, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process
Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version…
November 15, 2022
FP&A Done Right: Approaches to Long-Term Planning
“If you fail to plan, you are planning to fail.” – Ben Franklin In our collective rush to react to ever-changing marketplace dynamics and shifts in the economy, it’s easy to focus on short-term plans, to the neglect of long-term planning. Today’s…
November 14, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview
IBM Planning Analytics Workspace (PAW) allows you to easily create selector widgets that can be used for updating the data in your PAW book. This is done by adding a dimension as a selector widget. You can edit the list of elements…
November 1, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace
IBM Planning Analytics Workspace (PAW) allows you to easily create buttons that can be used for navigation and to run TurboIntegrator (TI) scripts. This is done by dragging the Action Button widget onto the sheet. By default, the button appears as a…
October 25, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MDX Syntax Explained
MDX enables you to query dimensions and cubes, lists of elements, data points, calculations, and more. The first step in learning MDX is to understand the syntax. Below is an example of an MDX expression that returns all elements of the product…
October 18, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar
Do you regularly work with others that are in a different time zone? If so, how often have you heard your counterpart tell you to “just determine my time by adding X hours to yours.” And how often have you messed up…
October 4, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: 21/21/21
Some of you may remember an Excel feature that we wrote about a while back, which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020, since there are not…
September 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Garbage Memory
I recently had a customer ask me why Windows was showing a much larger memory footprint than what was expected (based on their cube sizes). After further analyzing their model, we saw a large amount of garbage memory … which led to…