TM1 Forum

Hi All,

it is very very urgent, really appreciated your support and reply at the earliest.

i have two different set of hierarchies but some common elements so i need to hide the "USA" hierarchy including all the corresponding leaf level elements for all the users except admin users.
please refer the attachment sample.

and help me with your experience possible or not. or is there any way to use mdx query to approach this.

Thanks,

A quick reply...........

Yes, you can use Element security.
Yes, you can use MDX.

What is your issue ? What did you try ? What interface do you use ?
And probably many more questions can be asked, because you did not give a lot of information.

Hi Mincharug Shulft ,
As per the my understanding,
kindly try this MDX code for the dimension i think this will solve your purpose.
in this "Dimension_Name" refers to the name of the dimension in which the elements are present and I have hard coded Americans as you need that to be displayed.

{ HIERARCHIZE( {TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( { HIERARCHIZE( {TM1SUBSETALL( [Dimension_Name] )} ) }, "Americans")}, ALL, RECURSIVE )} ) }

Hi Wim Gielis, these (Americans, USA) two hierarchies are present in one Dimension and Supper user requested for, should not see the "USA" hierarchy by all the users including all the corresponding leaf level elements except admin users even when user click on "All" option.as stated in my first post, those are the common elements from both hierarchies.you can refer the attachment sample in my previous post.

Thanks vaibhav for your valuable reply.... i am going to see the results based on your answer however btw one quick question: is that possible of hiding "USA" hierarchy alone for all the users except admin users.

mincharug.shulft wrote:Thanks vaibhav for your valuable reply.... i am going to see the results based on your answer however btw one quick question: is that possible of hiding "USA" hierarchy alone for all the users except admin users.

The easiest way to do that is to just apply element security to the dimension.
MDX is a great asset but shouldn't be used for applying pseudo-security.

MS

What you ask is the textbook example of elementsecurity. What difficulty are you experiencing in applying that ?

Wim

Hi Wim Gielis, When my user click "All" option in subset editor he is able to see both hirerachies who is not admin, he should not see "USA" hirerachy and he wants to see "Americas" hirerachies only , that is my requirement. pls help me with your expertise how to hide it or provide security

It's not that difficult to use Google or go to the TM1 documentation.
For example with Google, you can find very easily:
http://www.ibm.com/developerworks/libra ... index.html

Hi Hi Wim Gielis, not sure if would have followed by conversion, all googling i have done so only i posted in this forum.

if i provide Security is "None" for "Rolf" element in "uSA" hierarchy to normal user then he/she wouldn't able to see any of the hierarchy, but my requirement is not to see "USA" hierarchy for all the normal user even when user click on "ALL" in subset editor only "Americans" alone should able to see it all the time. not sure whether that is possible or not

Hi
Suggest you read the section of the TM1 Operations Guide titled "Managing Users and Groups", you'll need to fully understand all aspects of security before doing any implementation of it. The manual will get this information across much better than any protracted Q & A session on the forum.
If you have questions once you have reviewed this chapter and have tried to implement the concepts contained there, then please do come back.

What you need to do is something like the following but please review the above first so you can understand what you are doing and why.
1. Create a group, lets call it HideHierarchy.
2. Add all the user you want to that group.
3. Right click on the region / geography dimension.
4. Give HideHierarchy None access to USA

That should be it.

Apply NONE rights for the element USA only, as the children of that element all appear in the other hierarchy.