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…
January 19, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TYPE Function
Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell. Excel has a function called…
January 12, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation
Have you ever wanted to quickly go to the last used cell within a spreadsheet but did not know how? Have you ever wanted to determine where the next available row or column resides? Have you ever wondered why a spreadsheet with…
January 5, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Rule Editor Keyboard Shortcuts
Are you an “old school” keyboard person that still presses Ctrl-S to save your Excel workbooks? Do you flip through windows by pressing Alt-Tab? Do you remember Lotus backslash macros that used commands such as /FS for File, Save? If so, did…
December 15, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Log Lock Notification
Have you ever tried to move or download log files and then realize that some of the files cannot be modified since they are in use? IBM Planning Analytics Workspace (PAW) recognizes this and now offers notifications to let you know which…
December 8, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports
In the early days of computing, printers often used paper that had alternating white and green areas which allowed the reader to easily follow a line of text across the page. This was known as “green bar” paper. While we no longer…
November 10, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area
Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding…
November 3, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Show Members
Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here's how you can do this: Step 1: Select the dimension to be…