Cell Security Rules not compiling
Posted: Fri Apr 17, 2015 3:56 pm
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?
}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?