IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Collect Feature in Planning Analytics Workspace
Did you know that you can easily copy Planning Analytics Workspace (PAW) components across sheets or books? PAW allows you to use a feature called “Collect” that serves as the equivalent of copying. You can collect an item by selecting the item…
January 15, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using Excel to get Client Information
Did you know that you can now easily define your client version of Planning Analytics via an Excel formula? There are many ways to determine your version of Planning Analytics. Some of these approaches include reviewing log files, right clicking on executable…
January 8, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Compatibility of Views and Subsets
Did you know that your parameters for VIEWCREATE and SUBSCREATE must be in sync? Earlier this year we wrote a blog post about a new parameter that can be used with both the VIEWCREATE function and the SUBSETCREATE function. This new parameter…
December 18, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Synchronizing Selectors with Planning Analytics Workspace
Did you know that you can easily synchronize your selectors with your IBM Planning Analytics Workspace (PAW) components? PAW allows you to synchronize your widgets to a selector or set of selectors. This ensures that a change in your selected elements impacts…
November 13, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace
Did you know that there are different ways to create selectors in IBM Planning Analytics Workspace (PAW)? TM1 Perspectives allows you to create selectors via the SUBNM formula. This approach offers an easy way to create a selectable list on a report…
October 30, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Writing Rules
Did you know that that way you write your rule could impact the performance of the model in IBM Planning Analytics? There are three parts to a rule. The area definition describes the section of the cube to which the rule will…
October 16, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace
Did you know that you don’t have to show all of your dimensions during an ad-hoc query in IBM Planning Analytics Workspace (PAW)? TM1 cube views and formulas require a reference to every dimension within the cube. While all of these dimensions…
October 2, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Bookmarks in Planning Analytics Workspace
Did you know that you can bookmark items for quick navigation in IBM Planning Analytics Workspace (PAW)? PAW’s navigation menu allows you to scroll through your entire system which includes cubes, dimensions, views and other aspects of your model. This ability to…
September 18, 2018
IBM Planning Analytics Tips & Tricks
IBM TM1 Tips & Tricks: When to Build Multiple Cubes
When working with clients to design a TM1 system, I sometimes have clients ask about an approach of building one cube for a model vs. building multiple cubes for a model. What do I mean by that? A cube consists of a…