Element security Control Objects

Post Reply
User avatar
Chengooi
Posts: 64
Joined: Tue Jan 13, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Auckland, New Zealand
Contact:

Element security Control Objects

Post by Chengooi »

Can anyone tell me how to set up Element security for a dimension.
I have look through all "Help" and they are not pointing to what I needed.

It's simply a dimension consist of thousands of elements. We want to control the WRITE access to some of the elements.

Can someone please help me?
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Element security Control Objects

Post by Alan Kirk »

Chengooi wrote:Can anyone tell me how to set up Element security for a dimension.
I have look through all "Help" and they are not pointing to what I needed.

It's simply a dimension consist of thousands of elements. We want to control the WRITE access to some of the elements.

Can someone please help me?
Now I'm not sure whether you're:
(a) Extracting the Michael;
(b) Trying to get a rise out of Lotsaram; or
(c) Asking a serious question.

I'm not sure how much clearer the 9.0 Security Guide (page 6-14) can make it, but you simply:
- Right click on the dimension;
- Select "Security" from the pop-up menu, then "Element Security Assignments";
- In the dialog that appears you find and select the cells that you want to limit access to (that is, the intersection of the element names and the security group names);
- Click on the "Read" radio button at the bottom of the dialog; then
- Click the [Save] button.

This will create the }ElementSecurity_DimName cube, which you can use to set the security afterwards if you don't want to use the dialog.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Chengooi
Posts: 64
Joined: Tue Jan 13, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Auckland, New Zealand
Contact:

Re: Element security Control Objects

Post by Chengooi »

yes, spot on Allan.
You are genius, I though that was the case ut somehow my departure "spirit" has blocked me from thinking further about it.

Thanks again.

:lol:
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
Post Reply