Hi,
I have encountered the same problem, as mentioned in
http://groups.google.com/group/micro...4 6941456a5d0
But unable to found any solution.

I am Using Dynamic Security for different User roles
Role 'A': got 'Full' level accessible on time Dimension
Role 'B': only got 'DAY' accessible

I am also using Distinct Count Measure in my cube in AS2000.

While running the Following on 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]


Error Arise:: Formula error - cannot bind: unknown member: "Time.[-Sub
Total]"

However, this query run successfull when user login with Role 'A'
I request you Gurus to please help me .

preeti