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 … [Read more...] about IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Greenbar
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW
IBM Planning Analytics Tips & Tricks: PAW Border Lines
The great thing about explorations is that data appears in a simple grid-like format. This allows you to easily look at your data in an easy-to-read format that is similar to an … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Border Lines
IBM Planning Analytics Tips & Tricks: Excel’s WRAPCOLS Formula
Have you ever needed to modify a list in Excel without wanting to manually manipulate the data? Excel’s WRAPCOLS formula lets you reshape data without having to perform tedious … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel’s WRAPCOLS Formula
IBM Planning Analytics Tips & Tricks: PAW Enter Members Feature
Have you ever created an IBM Planning Analytics Workspace (PAW) exploration and then wanted to look at data that was not in your original set? You can open the set editor and … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Enter Members Feature
Industry Analysts’ Take on F&A Priorities
This is a blog post from our partner BlackLine, highlighting the top three F&A priorities according to analysts at The Hackett Group and ISG Ventana Research. As automation … [Read more...] about Industry Analysts’ Take on F&A Priorities
IBM Planning Analytics Tips & Tricks: VSTACK_HSTACK
In a previous blog, I wrote about the ability to convert a list into a set of smaller lists (create a link to the WRAPCOLS blog). But what if you wanted to do the opposite? What if … [Read more...] about IBM Planning Analytics Tips & Tricks: VSTACK_HSTACK
IBM Planning Analytics Tips & Tricks: PAW Workbench Go To Rule
Have you ever referenced a view in an IBM Planning Analytics workbench and then realized that you also want to look at the rules associated with the cube? You can do this by … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Workbench Go To Rule