Element hide in tm1

Post Reply
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Element hide in tm1

Post by mincharug.shulft »

ele,ent security
ele,ent security
Capture.PNG (2.83 KiB) Viewed 7161 times
ele,ent security
ele,ent security
Capture.PNG (2.83 KiB) Viewed 7161 times

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,
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Element hide in tm1

Post by Wim Gielis »

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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Re: Element hide in tm1

Post by late.vaibhav »

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 )} ) }
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Element hide in tm1

Post by mincharug.shulft »

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.
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Element hide in tm1

Post by mincharug.shulft »

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.
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Element hide in tm1

Post by declanr »

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.
Declan Rodger
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Element hide in tm1

Post by Wim Gielis »

MS

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

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Element hide in tm1

Post by mincharug.shulft »

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
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Element hide in tm1

Post by Wim Gielis »

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
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mincharug.shulft
Regular Participant
Posts: 155
Joined: Fri May 20, 2011 8:17 am
OLAP Product: Applix,Cognos TM!
Version: applix9.0Cognos tm1 9.5.1
Excel Version: Excel 2010 2007

Re: Element hide in tm1

Post by mincharug.shulft »

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
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Element hide in tm1

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Element hide in tm1

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply