Simplifying IBM Planning Analytics Administration

Longtime Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

1. Simplify your Architect’s view. Turn off items that you don’t need in the View menu.

Turn off Applications and Replications, which will provide a less cluttered environment.
Applications and Replications

2. Create a custom private application (folder) in the Application Tree to group commonly used items:

Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

3. Create folders within folders for grouping tasks. Note: Numbering the folders helps with ordering the themes.

Create folders within folders

4. In a similar fashion, if you are in development mode, group the objects you are currently working on. Save time by not having to navigate up and down the TM1 tree.

Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

5. Turn on IBM Planning Analytics Administration Automatic Calculate. No need to always click the “Recalculate button”.  Note: Remember that the “F9” key can be used to refresh cube views.

Automatic Calculate

6. Use filtering for additional features like sorting/top/bottom counts and filtering:

Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

Sorting:
sorting

Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

Get the Top 5:
top 5

Data41 IBM Planning Analytics Architect, Chris Maling, offers up some quick tips on how to better navigate and use IBM Planning Analytics Administration.

7. Turn off the IBM Planning Analytics Administration properties window in the subset editor for dimensions with long lists of elements. In this example, the Account dimension has a consolidation with many accounts below it.  Clicking on “All Accounts” causes a long delay while the properties window populates.

Administration properties window

Click on the icon to toggle the properties window on and off.  Keeping it off will result in faster browsing in large dimensions.
toggle

Chris Maling

Based in Orange County, California, Chris Maling is a consultant for the IBM Cognos practice. Chris brings a strong technical background to Data41 with more than 18 years working in Business Intelligence and IT. This experience has proved to be an immense asset to Data41 and our clients. Outside of Data41, Chris enjoys cycling, hiking and fixing cars.

RECENT POSTS

SIGN UP FOR OUR NEWSLETTER