IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Tab Icons
Have you ever created an IBM Planning Analytics Workspace (PAW) book and wanted to include images within each tab? PAW version 57 introduced settings that allow you to control details about the tabs. Some of these settings allow you to insert icons into the…
June 15, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Tab Colors
Have you ever created an IBM Planning Analytics Workspace (PAW) book and wanted to have more control over the look of the tabs? PAW version 57 introduced many settings that allow you to control formatting details about the tabs. These details include settings that…
June 1, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Axis Labels
Have you ever created a chart in IBM Planning Analytics Workspace (PAW) and wanted to change the angle which the labels appear? PAW version 57 has introduced a setting which allows you to control the labels in much greater detail. This is done…
May 18, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Filter in IBM Planning Analytics Workspace
Have you ever wanted to show the top values within an IBM Planning Analytics Workspace (PAW) exploration? This can be done by creating a filter within your view. Assume we start with a view that shows 2019 operating expenses by department: We…
May 4, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Gridlines
Have you ever created a PowerPoint slide by using gridlines to position your pieces and wished that you can do the same in IBM Planning Analytics (PAW)? Now you can! PAW version 57 introduced many settings that allow you to further customize…
April 20, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MS Word AutoCorrect
Part of implementing IBM Planning Analytics is ensuring that users understand their model. This often entails documentation that is created as a Microsoft Word document. Most of us know how to use Word but get frustrated typing some of the complex OLAP…
March 30, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Manipulating Text in Excel
Have you ever wanted to manipulate text within Excel? Excel has a series of functions that allow you to parse text strings based on whether you want to reference the left, the right, or the middle of the cell contents. For example,…
February 2, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s NETWORKDAYS Function
Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS…
January 26, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Waterfall Chart
IBM Planning Analytics Workspace (PAW) includes various visualizations that can be used to view your data. One of these visualizations entails a chart called a waterfall chart. This type of chart will help you show the components of a summarized number and…