Rights saving error

Post Reply
dinko
Posts: 3
Joined: Wed Nov 03, 2010 9:51 am
OLAP Product: Cognos TM1
Version: 10.2.2 FP7
Excel Version: 2013

Rights saving error

Post by dinko » Mon Nov 13, 2017 9:58 am

Hi!

We've got several issues when updating security rights within TM1 Application (TM1 10.2.2 FP7 and only Production server, 10.2.2 FP6 worked fine).

1. Error description:
Sometimes we have to change approval hierarchy and save rights. There is an issue with some applications as result (see screenshot).
We can just export and import an application with rights and it has no errors next time with rights saving.
But this decision has several minuses as:
- the order of applications are broken
- applications states (statuses) are reset

2. Saving rights takes a lot of time (several hours). There are a lot of info in the server log file like this:
INFO 2017-11-09 17:01:15.808 TM1.Cube.Dependency Adding cube dependency: Cube '}CellSecurity_cKPIMetric1' depends on cube '}tp_intermediate_RDCLS}cKPIMetric1'.
INFO 2017-11-09 17:01:15.808 TM1.Server TM1CubeImpl::ProcessFeeders: Done computing feeders for base cube '}CellSecurity_cKPIMetric1'.
INFO 2017-11-09 17:04:24.459 TM1.Cube.Dependency Adding cube dependency: Cube '}CellSecurity_cKPIMetric6' depends on cube '}tp_intermediate_RDCLS}cKPIMetric6'.
INFO 2017-11-09 17:04:24.459 TM1.Server TM1CubeImpl::ProcessFeeders: Done computing feeders for base cube '}CellSecurity_cKPIMetric6'.
INFO 2017-11-09 17:04:40.449 TM1.Cube.Dependency Adding cube dependency: Cube '}CellSecurity_cKPIMetric1' depends on cube '}tp_intermediate_RDCLS}cKPIMetric1'.

3. After an application redeploying the order of rules blocks (manual and automatically generated) has changed in }CellSecurity_Cube.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion

[] = S: IF(
ELLEV('CFR2', !CFR2) <>0 % ELLEV('LiquidityTerm', !LiquidityTerm) <>0 %
ELLEV('Time', !Time) <>0 % ELLEV('z2405LoanR', !z2405LoanR) <>0,
'READ',
CONTINUE);

#Region tp_planning_rule
[]=S:IF(DB('}tp_intermediate_RDCLS}c2405LoanR',!CFR2,!Revision,!}Groups,'all_applications','StaticRights')@<>'',DB('}tp_intermediate_RDCLS}c2405LoanR',!CFR2,!Revision,!}Groups,'all_applications','StaticRights'),CONTINUE);

#EndRegion
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
And we have to fix the order every time after an application redeploying.
----------------------------------------------------------------------------------------------------------------------------------
Could you help us?

Thanks in advanced.
Attachments
Capture1.PNG
Capture1.PNG (26.69 KiB) Viewed 88 times

Post Reply