I have a twelve dimension cube that I want to apply security against. I want to apply security on only three of those dimensions though. So I've set up a string cube to enter the information against it. The dimensions are Company, Scenario, Period and String.
In my Cell Security cube for the cube with the data I've set a rule up that says
Code: Select all
[]=S: if(db('zSecurity', !Company, !Scenario, !Period, 'String')@='', 'READ', db('zSecurity', !Company, !Scenario, !Period, 'String'));
I've then set up a view that is very high level, but as far as I can figure out it still only needs to calculate one cell as S: rules don't consolidate (do they?), so to my mind it should take all of a nanosecond. However it's taken about five minutes so far and the CPU on the server is up to capacity.
What have I done wrong?
Martin