IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells
Did you know that update 76 of IBM Planning Analytics allows you to customize background colors for data and header cells within your Planning Analytics Workspace (PAW) views? To customize these colors, click on a view within a page in PAW and…
August 9, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel
Do you know how to add a new Connection URL or Edit an existing Connection URL in Planning Analytics for Excel? Here are the steps to follow: Adding a Connection URL Once Planning Analytics for Excel has been launched, go into the…
August 2, 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: PAW Chart Show Totals
One of IBM Planning Analytics’ purposes is to serve as an aggregation tool. As a result, many of your explorations consist of a series of base level elements plus a total. Here is an example of a simple exploration that shows details…
July 19, 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: PAW Escape Character
Have you ever been in a situation where you have an element name with an apostrophe (or two) in IBM Planning Analytics? Examples of this might entail last names such as “O’Connor” or “O’Sullivan”? Although IBM best practices specify that the apostrophe…
July 5, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube
Did you know you can use MDX to create dynamic subsets based on cube values in IBM Planning Analytics? In our example we will only show companies with net sales greater than 30,000,000 in the selected year. An MDX statement that can…
June 28, 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…
June 21, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…