IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube
Did you know you can use MDX to create dynamic subsets based on cube values in IBM Planning Analytics? In our example we will only show companies with net sales greater than 30,000,000 in the selected year. An MDX statement that can…
June 28, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Visualization Axis
Did you know you are able to create custom axis labels for IBM Planning Analytics Workspace (PAW) visualizations? Below is a column visualization that shows periods on the x-axis and a net income amount on the y-axis. As you can see, a generic…
May 24, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Visualization Value Labels
Do you know how to add value labels for Planning Analytics Workspace (PAW) visualizations? On the column visualization below, you can see the bars but you cannot see the exact amount of each column. To enable value labels, ensure that you are…
April 26, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically
Did you know that you can have IBM Planning Analytics Workspace (PAW) visualizations refresh automatically? To enable this setting, first make sure you are in “Edit” mode within your PAW book. You can then click on your visualization then click “Properties” in the…
March 29, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Modeling Books
Did you know IBM Planning Analytics Workspace (PAW) update 57 introduced a new type of PAW book? This new type of book is called a “Modeling Book.” A modeling book can be created by selecting the “Data and Models” tile at the…
January 18, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1PRIMARYDBNAME
Did you know there is a function to dynamically retrieve your database server name in IBM Planning Analytics for Excel (PAx)? When creating reports and input templates in Planning Analytics for Excel you must reference the TM1 server name you are pulling/pushing…
January 4, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Accessing Books
Did you know that there are now two ways to access books in IBM Planning Analytics Workspace (PAW)? Previously, you could access books via the “Shared", “Personal”, and “Users” folders in the bottom section of the home page. This option still…
June 8, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Home Page Refresh
Did you know that the home page has received a major refresh in IBM Planning Analytics Workspace (PAW) update 57? Previous versions of PAW contained a lot of unused space and the look and feel changed as you moved from the…
April 27, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Database Administration
Did you know that database administration page has been updated in IBM Planning Analytics Workspace (PAW)? In previous versions of PAW you would click on a database and it would present detailed information as seen below. With the “Database Settings” button…