Hi,

I have a dimension DIM in whcih there are columns Col1 , Col2, Col3 ,
Col4. Col1 and Col2 are the levels to this dimension. I want to
filter this dimenison based on the Roles created. Col3 has vlaues
1
2
3
4.
For a role Test i want to show the dimension data where Col3 = 2.
i,e i want to filter the DIM data based on COl3 whcih is not a level and
the filtering condition varies from role to role. Please let me know how
to go about this problem.

Solution i tried. But invain :-(
1)
I tried to create Col3 as the first level and select the values based on
the roles. But, in the report the level Col3 should not show up. So, i
made the level properties "Visible" as False. By this the Col
disappeared from the "Manage Role " window also and the filtering
condition did not work.
2)
I tried to make Col3 as the member propety for Col2 which is the second
level. In
Manage Roles -> select role -> Dimension tab -> select custom ->
Advanced tab -> Allowed members ,
i used the following code
filter({DIM.members} , DIM.currentmember.properties("COL3") = 2)
the cubes processed successfully, but the dimension was not filtered
on COL3 = 2.

--
Posted via http://dbforums.com