IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Filter in IBM Planning Analytics Workspace
Have you ever wanted to show the top values within an IBM Planning Analytics Workspace (PAW) exploration? This can be done by creating a filter within your view. Assume we start with a view that shows 2019 operating expenses by department: We…
May 4, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Gridlines
Have you ever created a PowerPoint slide by using gridlines to position your pieces and wished that you can do the same in IBM Planning Analytics (PAW)? Now you can! PAW version 57 introduced many settings that allow you to further customize…
April 20, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MS Word AutoCorrect
Part of implementing IBM Planning Analytics is ensuring that users understand their model. This often entails documentation that is created as a Microsoft Word document. Most of us know how to use Word but get frustrated typing some of the complex OLAP…
March 30, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Manipulating Text in Excel
Have you ever wanted to manipulate text within Excel? Excel has a series of functions that allow you to parse text strings based on whether you want to reference the left, the right, or the middle of the cell contents. For example,…
February 2, 2021
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…