Cell level Security based on a cell value

[manoj928]

Hello All,

I have requirement where i need to hide a row from user belong to a specific group in Cube view. And the condition is based on a cell value for a measure. I am trying to implement it through Cell security using logic below:

[{User Group},{all measure elements}] = S:IF(DB(Cube Name, 'Dim 1','Dim2',.......,'A measure element') = 0,'NONE', CONTINUE);

I check it and it is not working. So please let me know if i am missing anything or if there is good practice to achieve it differently.

Any help would be really appreciated.
Thanks,
Manoj

[tomok]

If you are taking about dimension elements in an active form report or a cube view, when you refer to "rows", you can't hide them with cell level security. You can only hide rows with dimension security. With cell level security applied against the cube the elements will still show up but be zero.

[manoj928]

We have dimension as rows in cube, and then in cell we have all measures values. Now depending upon a measure cell value, we want to skip elements of all dimensions associated with that cell. I mean i don want to show that set of data in view.

[tomok]

That is not possible using cell security. Depending on what your model looks like, you might be able to create an MDX-based subset(s) for the dimension(s) in question to not show the row based on specific values in the cube.