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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Convert Existing View Directly to Reports
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, … [Read more...] about IBM Planning Analytics Tips & Tricks: Asymmetric Axis in PAW
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) … [Read more...] about IBM Planning Analytics Tips & Tricks: Log Lock Notification
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Rule Editor Keyboard Shortcuts
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel TYPE Function