Hi all,
I am stucked in a problem where I need your precious advice.
My scenario is I am Using Dynamic Security and using different roles
for accessing members.
For Example
Role 'A': got 'Full' level accessible on time Dimension (i.e.
All, Year, Quarter, Month)
Role 'B': only got 'DAY' accessible
In short, I have only bottom level visible for Role B. Moreover, my
cube contains a Distinct Count Measure. In consequence, I think I am
unable to go for 'Visual Totals'. I am using XMLA to query MS OLAP.
Can I create member on a different level (other than (All) and call
that member in the MDX for a restrictive role (i.e for Role 'B').
MDX QUERY:
With MEMBER [Time].[-Sub Total] AS ' SUM
(GENERATE(HIERARCHIZE(DISTINCT({Time.[Year].Members})),
HEAD(INTERSECT(HIERARCHIZE(DISTINCT({Time.[Year].Members})),
ASCENDANTS(Time.CurrentMember)))))' , SOLVE_ORDER = 1000
SELECT {[Unit Sales]} ON COLUMNS, {{Time.[Day].Members, Time.[-Sub
Total]}} ON ROWS FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL]
While executing the above Query for a user login with Role 'B' I
receive Following Error
Formula error - cannot bind: unknown member: "Time.[-Sub Total]"
However, it works fine for a user login with Role 'A'
Can some body help...
Thanks in advance.
Kind Regards
--danishnajam
|
