Dimension Security -
12-01-2005
, 04:22 PM
select [Measures].[SF Access]on columns,
FILTER ([Dim Customer].[Customer Name].Members, (Strtotuple(Mid (username,
instr(1, username, "\") + 1,128)) , [Measures].[SF Access]) = 1)
on rows
from [demo1]
The query works in Management Studio. Not sure where and how to setup under
the advance tab in dimension security...I am green with regards to MDX
expressions. Any suggestion or are there any example using data driven
security in AS 2005?
Thanks
--
tobemdx |