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?
Cell Security Rules not compiling
- 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
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
-
- 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
Are the Counter and Regions dimension part of the cell security cube?
-
- 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
Yes they are.
-
- 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
@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.
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.