Hi,
I wonder if I have a way to restrict and allow certain user group to see specific alias set only for dimension element.
I did some research and don't find a way but would like to confirm from other user.
Thanks.
Security on Alias Set
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Security on Alias Set
Hi
What about element security on the element attributes dimension ?
What about element security on the element attributes dimension ?
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Security on Alias Set
I read from other post that element attribute can't be assigned with security.
I will follow your suggestion and see.
Thanks! You're as helpful as you've always been.
Ken
I will follow your suggestion and see.
Thanks! You're as helpful as you've always been.
Ken
- qml
- MVP
- Posts: 1097
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Security on Alias Set
I'm afraid you cannot hide aliases using element security, but this thread might give you some other ideas to explore.
Kamil Arendt
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Security on Alias Set
I read this thread already.
And I tried working with security on }ElementAttributes.
Unfortunately it doesn't give me what I want.
Anyway, thanks.
Ken
And I tried working with security on }ElementAttributes.
Unfortunately it doesn't give me what I want.
Anyway, thanks.
Ken
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Security on Alias Set
Apologies, I did not answer the question and you can disregard my reply.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Security on Alias Set
Please do not worry about it at all.
- qml
- MVP
- Posts: 1097
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Security on Alias Set
Have you considered my suggestion from the linked thread to have the attribute values rule-derived, using the TM1USER function as a dynamic variable helping you to decide who should see what?
Edit: here's a rule sample to demonstrate what I mean.
Edit: here's a rule sample to demonstrate what I mean.
Code: Select all
[}ElementAttributes_MyDim:'My Alias'] = S:
IF( DB( '}ClientGroups', TM1USER(), 'MY_ALIAS_SECURITY_GROUP' ) @= 'MY_ALIAS_SECURITY_GROUP',
DB( 'My_Alias_Helper_Cube', !MyDim, 'My Alias' ),
''
);
Kamil Arendt
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: Security on Alias Set
I haven't tried but will certainly take a look.
Thanks!
Thanks!