Security on Alias Set

Post Reply
kenship
Regular Participant
Posts: 194
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: Planning Analytics 2.0.7
Excel Version: 2010

Security on Alias Set

Post by kenship »

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.
Wim Gielis
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

Post by Wim Gielis »

Hi

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
kenship
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

Post by kenship »

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
User avatar
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

Post by qml »

I'm afraid you cannot hide aliases using element security, but this thread might give you some other ideas to explore.
Kamil Arendt
kenship
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

Post by kenship »

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
Wim Gielis
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

Post by Wim Gielis »

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
kenship
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

Post by kenship »

Please do not worry about it at all.
User avatar
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

Post by qml »

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.

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
kenship
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

Post by kenship »

I haven't tried but will certainly take a look.

Thanks!
Post Reply