Page 1 of 1

Cell Security Rules not compiling

Posted: Fri Apr 17, 2015 3:56 pm
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?

Re: Cell Security Rules not compiling

Posted: Fri Apr 17, 2015 4:07 pm
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?

Re: Cell Security Rules not compiling

Posted: Fri Apr 17, 2015 4:08 pm
by tomok
Are the Counter and Regions dimension part of the cell security cube?

Re: Cell Security Rules not compiling

Posted: Fri Apr 17, 2015 4:47 pm
by dharav
Yes they are.

Re: Cell Security Rules not compiling

Posted: Fri Apr 17, 2015 5:01 pm
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.