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: Asymmetric Axis in PAW
One of the helpful features of IBM Planning Analytics is the ability to create explorations using asymmetric axes. This is useful when you have stacked column or row dimensions, and only want to display certain combinations of elements instead of all combinations…
December 1, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports
Did you know that Planning Analytics for Excel (PAx) provides the ability to convert an existing view directly to a report in Excel? Without opening the view as an Exploration, you can start building your report directly from the Task Pane. Just…
November 24, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab
Did you know that Planning Analytics for Excel (PAx) automatically keeps track of the Planning Analytics objects you have open in an Excel workbook? Simply click on the Workbook tab of your Task Pane to view the list of Dynamic reports, Action…
November 17, 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…
October 27, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills
Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to…