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…
August 23, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DELET Function
A while back I wrote a blog about the SCAN function which showed how you can search for specific characters and then combine this with the SUBST formula to create new sets of text. But what if you wanted an easier way…
July 26, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS
Many of you know that Excel’s MAX function will define the largest value within a range. And many of you also know that Excel’s SUMIFS function will allow you to merge IF checks into your sum formulas. But did you know that…
July 12, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function
Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…