TM1 Forum

Hi guys,

Was wondering if anyone could offer any suggestions

In my tm1 cube view, I want to be able to filter a dimension by ALL elements, instead of having to choose a specific element.
(i.e filtering by the dimension header)

Just wondering if there is a way to do this WITHOUT having to create a new column in the data source to consolidate that element

captainkarisma wrote:Hi guys,

Was wondering if anyone could offer any suggestions

In my tm1 cube view, I want to be able to filter a dimension by ALL elements, instead of having to choose a specific element.
(i.e filtering by the dimension header)

Just wondering if there is a way to do this WITHOUT having to create a new column in the data source to consolidate that element

I think it may be time to hit the manuals to understand exactly how dimensions are structured.

A TM1 view consists of three areas, titles, columns and rows. You're talking about the titles area where you can select only one element. if you want to get an aggregate of all elements in a title dimension, you need to tell TM1 to create an consolidation element which adds them all together, and select that one.

You do not need a separate column in your data source to do this.

For each dimension you add a C (Consolidation) element called "Total (whatever)".

In the Metadata tab of your TI (I assume that you''re using a TI since you're talking about a data source) you use the DimensionElementComponentAdd function (which you can find described in the Reference Guide) to add each element to that Total.

You then select the Total element(s) in your titles.

If you want a sub-grouping of the elements then you still need a consolidation but if you need one that can be created on the fly look up "RollUp", "User Defined Consolidations" and "User Defined Calculations" in the manuals.