Cell Security Rules not compiling

Post Reply
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Cell Security Rules not compiling

Post by dharav »

Hello All!!!!


}cellSeucrity_Input:

['BaseForecast',{'Location','ID','Priority','Account','Comment'}]=
S: IF (DB('}tp_intermediate_RDCLS}Input',!regions,'all_applications',!}Groups,'StaticRights')@='' &
(ATTRS('Counter',!counter, !regions)@='R') ,
'READ',
Continue
);


Error:

!counter,!regions
invalid string expression
Rule could not be attached to the cube,but changes were saved


#===========================================================================================
FYI:
(ATTRS('Counter',!counter, !regions)@='R') ,

where,
'Counter' is a dim name
!counter - we use it as we considered all elements of this dim
!regions - we have created attribute with all region name which exist in the !region dimension

=> when i put

(ATTRS('Counter','1', !regions)@='R') ,

It works fine.
#--------------------------------------------------------------------------------------------------------------------------------------------------
I utilise same logic when i created the prototype and it was working fine. No error. I restored that directory and try to
map both model for a respective cube. I did not find any difference.
#==========================================================================================

Could you please help me out to understanfd the piece which i may ignored?
User avatar
qml
MVP
Posts: 1098
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: Cell Security Rules not compiling

Post by qml »

Do you have 'counter' as a dimension in the Input cube and its cell security cube (because it looks like you don't)? Actually, can you give us the full dimensionality of both of these cubes?
Last edited by qml on Fri Apr 17, 2015 4:08 pm, edited 1 time in total.
Kamil Arendt
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Cell Security Rules not compiling

Post by tomok »

Are the Counter and Regions dimension part of the cell security cube?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Cell Security Rules not compiling

Post by dharav »

Yes they are.
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Cell Security Rules not compiling

Post by dharav »

@tomok and @qml:

Thanks for your time.

It works good now.

I just copy rules in to a text file. I upload empty rule file and than with rules. It got saved.

I didn't realize what was the issue.

Thank You all again for your time and efforts.
Post Reply