IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW
Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics…
April 30, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Greenbar
Have you ever generated an IBM Planning Analytics Workspace (PAW) exploration and struggled to read the values in the grid? For example, how easy is it to define the travel cost for department 55 in the screenshot below? A few years ago,…
April 16, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function
Have you ever needed to export Excel data in a format that can be read by other systems? Although csv files are widely accepted, many legacy systems expect data in an array format. This can be done using the ARRAYTOTEXT formula in…
April 2, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW “Spacers”
Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) that contains a lot of data and wish that you could separate the information? PAW allows you to insert blank rows and columns called “spacers” into your exploration. Here is…
March 19, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s ROUND Function
Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000. This is done in Excel via the ROUND function. The function has two parameters: =ROUND(number,…
March 5, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Switch Function
The SWITCH function in Excel evaluates a condition and then provides a result based on that condition. This function is similar to a SQL CASE statement and allows for up to 126 potential results. The syntax of the SWITCH function is: =SWITCH(expression,…
February 20, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Generated Statements
One of the great things about IBM Planning Analytics Perspective’s process editor is that the wizard can be used to create code within your scripts. The results of the wizard based statements are inserted within areas called “Generated Statements.” However, there may…
February 6, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total
Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For example, the branches in a region or the…
January 23, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXT Function
Have you ever merged text and a calculated number into a cell and saw that the format of the number was hard to read? The TEXT function in Excel lets you convert the number into a more professional format. The syntax of…