Dimension Question

[Kazêh]

Hello all, pretty simple question here, im still new to tm1.

I created a dimension with the follow hierarchy

Total
Element1
Element2
Element3
Element4


Where total consolidate those elements. Now i have a view with only Total and element1 and 2, i hide element 3 and 4, but , when i click the total again in the view on architect, it show me again element 3 and 4, i want to be able to click the +Total and see only element1 and 2.

is that posible? or that's how tm1 works? i know you can implement security on the dimensions for groups to see only a few elements, but that's the only way?
sorry for my bad english, not my native language.
Thanks for any help.

[Duncan P]

I'm afraid that is how TM1 works. What you are defining in the view, or in a subset, is what the user sees initially. By expanding "Total" they are effectively asking for all its children, so that's what they get.

[Kazêh]

Thanks for the answer Duncan

[Darkhorse]

Use roll up

[Alan Kirk]

Hello all, pretty simple question here, im still new to tm1.

I created a dimension with the follow hierarchy

Total
Element1
Element2
Element3
Element4


Where total consolidate those elements. Now i have a view with only Total and element1 and 2, i hide element 3 and 4, but , when i click the total again in the view on architect, it show me again element 3 and 4, i want to be able to click the +Total and see only element1 and 2.

is that posible?

As Duncan said, it's the way TM1 works... but there is nothing to stop you from adding elements to multiple consolidations. These can be in separate hierarchies, or in the same hierarchy. So you can have, say:

Code: Select all

Total
    Element 1
    Element 2
    Element3
    Element4

as well as another hierarchy which is

Code: Select all

Total Element 1 and 2
    Element 1
    Element 2

(The Totals consolidations need to have different and unique names.) You could then use Total Element 1 and 2 in your view instead of "Total"

Another option is to roll it up within the one hierarchy:

Code: Select all

Total
    Total Element 1 and 2
        Element 1
        Element 2
    Element3
    Element4

so that instead of adding element 1 and 2 directly into total, you add the sub-total Total Element 1 and 2. Again, your view would use that consolidation rather than the Total one.

Also, I would recommend against trying to do what you're doing. Even if you only show Elements 1 and 2 in your view, Total will still be the total of all elements. So if you have, say, 10 in Element 1, 20 in Element 2 and 5 in Element 4, you're going to see the Total showing 35 even though the total of elements 1 and 2 will be only 30. This would be confusing for the end user. That's why using a sub-total, and giving the user a view consisting of the sub-total and its children, is the better way of approaching this.

[nick_leeson]

Alan a wonderful answer and well explained perhaps could go straight into a new thread called "Pearls of Wisdom".

[Alan Kirk]

Alan a wonderful answer and well explained perhaps could go straight into a new thread called "Pearls of Wisdom".

Thank you, though it's probably more the case that what has become second nature to those of us who have worked with the tool for years is new and unexplored to someone who is:

still new to tm1.

hence the reason that I neglected to mention that Element 3 and Element 4 could also be removed from the view (for non-admins) via element security, since it was (to the eyes of an experienced user) too obvious (as well as the original poster mentioning that possibility, meaning that they were aware of it). Though that is emphatically also not recommended for the same reason, that the users will end up seeing a total which may not be the total of the elements that they see.

[Kazêh]

Thank you for your replies, Alan, Duncan, i will try this out.
I'm learning more and more tm1, but pls be patient with me, as i already said it, im new to tm1, and my native language is no english , even when i have no trouble reading it , sometimes i have trouble trying to express what i want to make. But , anyways, thanks for the replies.