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.
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 the report. Otherwise, it will be more efficient to save these elements under a consolidated element.
Let’s say aside from reporting 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.
The result is shown below.