TM1 Forum

Hello All

I have a following requirement to assign rights for a user.

Requirement:

I have to allow user Read access at Top Consolidation level and submit rights for second consolidation level.

E.G.:
USA
New Jersey
Union
Jersey City
Princeton
New York
Brooklyn
Midtown
Uptown

In this case i want to assign one user the read access at USA and right access at new york
another user i have to assign read access at USA and right access at Midtown.
Can i do it utilizing view depth? I am doing experimenting.

Plz let me know if you can help me

Thanks

Dharav

USA is first consolidation
New Jersey and New York are second level consolidation
Rest of them are N elements

Have you tried setting element level security? As long as your 2 guys are in different groups what you trying to do is pretty easy.

Jim

I am working on it. Element Security i would recheck though want to let you know that the region dimension has been used in approval hierarchy in contributor. We have 10.2 TM1 Environment. Once we put approval hierarchy along with control dimension than element security are not seems to active. Cell security is active after deploying the applications.


Guide me if i am in different direction.

Thanks

Dharav

Hi Dharav,

You can still use element security although TM1 10.2 is utilising cell security to manage rights. Please try the following:
1. Set up security using element security
2. insert a rule (shown below) in cell security to check both the rights assigned and the element security cube. replace the DimName with the dimension where element security is on
[] = S:IF(DB('}ElementSecurity_DimName', !DimName, !}Groups) @='READ'
& DB('}tp_intermediate_RDCLS}CubeName',!ApprovalHierarchy,'all_applications',!}Groups,'StaticRights')@<>'',
'READ',
CONTINUE
);

For more information:
http://www-01.ibm.com/support/docview.w ... wg21659499

Hope this helps

Hi Dweebernot

Thanks for your reply.

How could i treat in following events:

Event1:

View:1

Dim4: New York (Region)

Dim1 Dim2 Dim3
Jan Feb Mar Apr May
Current Year R1
R2
R3
R4 12% 14% 16% 20% 24%
R5
Prior Year R1
R2
R3
R4 5% 10% 15% 20% 25%
R5
Variance R1
R2
R3
R4 Should be hide
R5
Before creating an application:
Here, I want to hide R4 at variance element. I wrote cell security rule ['Variance','R4']=S:'None';
After Creating an application:
Would it be effective, as it modifies the cell security cube?

Event 2:

View 2 and view 3 are the examples to describe the scenario.

View:2

Dim4: New York (Region)

Dim1 Dim2 Dim3
Jan Feb Mar Apr May
Current Year R1
R2
R3
R4 12% 14% 16% 20% 24%
R5
Prior Year R1
R2
R3
R4 5% 10% 15% 20% 25%
R5
Variance R1
R2
R3
R4 Should be hide
R5

View :3


View:1

Dim4: Uptown (Metros)

Dim1 Dim2 Dim3
Jan Feb Mar Apr May
Current Year
R1
R2
R3
R4 Should be hide
R5
Prior Year
R1
R2
R3
R4 Should be hide
R5
Variance
R1
R2
R3
R4 Should be hide
R5

Users want to hide the R4 element at each region but should be available at each metro in the formate of view 2.
I wrote cellsecurity rules before creating an application:

['Region','R4']=S:'None';

Its not working and user couldn't able to see any data.


Could you plz let me know how to handle this requirements in tm1 10.2?


Thanks

Dharav