Neglected Functionality – Custom Rollups & Subset Consolidations

In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article I’m going to explain Custom Rollups and Subset Consolidations within IBM Cognos TM1.

Custom rollups are used to create a temporary user-defined consolidation element. It is a very useful, but somewhat underused functionality. With custom rollups, you won’t be able to save the subset but it is very useful if you ever need to create a consolidated element while browsing a cube, creating a report or reconciling child elements that do not share the same parent element.

Subset Consolidations are a more permanent solution for custom element aggregation which doesn’t require an administrator to build. These are elements which represent a subset and consist of the sum of all elements within that subset.

Below, I’ll guide you through how to use each of these pieces of functionality.

Custom rollups

The custom rollup function is only available when you open the subset editor from a cube view. As shown below, if we’d like to quickly view the total stationery sales for the entry-level product (those with code ending “1001”), we can accomplish this with custom rollups.

First, filter the elements with the code “1001” in it.

Then, click on the “Roll Up” button

And here is the result

Of course, this should be done only for ad-hoc, one time off report. Otherwise, it will be more efficient to save these elements under a consolidated element.

Subset Consolidations

Let’s say aside from reporting the the entry level products, we need to also show the sales figure of each product group from the Product Group subset.

This can be easily accomplished with the “Insert Subset” item. First, click on Edit and select Insert Subset.

Then select the subset you’ll like to show underneath the Rollup elements and click OK.

Result shown below.

 

 

If you like this post, please spread the love…
This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training. Bookmark the permalink.

3 Responses to "Neglected Functionality – Custom Rollups & Subset Consolidations"

Log in to post a comment.