Element hide in tm1
-
- 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
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,
-
- MVP
- Posts: 3120
- 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
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.
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
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
-
- 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
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 )} ) }
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 )} ) }
-
- 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
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.
-
- 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
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.
-
- 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
The easiest way to do that is to just apply element security to the dimension.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.
MDX is a great asset but shouldn't be used for applying pseudo-security.
Declan Rodger
-
- MVP
- Posts: 3120
- 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
MS
What you ask is the textbook example of elementsecurity. What difficulty are you experiencing in applying that ?
Wim
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
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
-
- 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
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
-
- MVP
- Posts: 3120
- 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
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
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
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
-
- 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
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
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
- Steve Rowe
- Site Admin
- Posts: 2417
- 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
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.
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
www.infocat.co.uk
-
- MVP
- Posts: 3120
- 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
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
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