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…
October 20, 2020
IBM Planning Analytics Workspace (PAW) Version 2.0.57 Release
IBM recently released Version 2.0.57 of Planning Analytics Workspace (PAW). Version 2.0.57 is currently offered as a local-only release and will soon be available on the cloud (as version 2.0.58). This update contains many significant changes, including both new functionality and a…
October 16, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset
Did you know that there are two different ways to sort elements within a subset in IBM Planning Analytics? Below is an example of a subset which shows a standard time dimension: One approach sorts all elements either ascending or descending, regardless…
October 6, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Editing Chores While Active
Did you know that IBM Planning Analytics Workspace (PAW) allows you to edit chores while they are active? Perspectives required you to de-activate a chore, make your modifications, and then re-activate it. However, the two “bookend” steps of this approach have been…
September 29, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Groups in PAW
Did you know that you can create new groups and delete groups directly in IBM Planning Analytics Workspace (PAW)? This is done within the dimension editor via the same screen that you use to edit dimensions and attributes. Step 1: Select the…
September 22, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel LET Function
Have you ever created a formula that repeats another formula within a cell? Did you know that this repetition may be slowing down your reports? For example, you may have a report where you want to pull IBM Planning Analytics data and…
September 8, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Control Space
Have you ever been deep in thought while writing a rule or a process only to realize that you forgot the parameters for a specific command? IBM Planning Analytics Workspace (PAW) has solved this dilemma by giving you the ability to determine…
September 1, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New PAx Feature – Double Click
IBM Planning Analytics for Excel (PAx) contains a task pane that shows the cubes within your model. Double clicking on a specific cube expands the information associated with the cube, including public views, private views, and the dimensions. Version 49 introduced a…
August 25, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Home Button
IBM Planning Analytics Workspace (PAW) offers an easy to use navigation menu that will quickly allow you to navigate to any open book. This is done by clicking on the menu at the top, center of your screen. Here is a sample…