Hello
One of my user can not access the top level of my dimension due to the
data security, I created a seperate role for him and I configured the
3rd level as the Top visible level for him like E.g. in Food Mart

Store dimension I set the visible Top level to [Store City], now when I
query the following query

With
MEMBER [Store].[-Sub Total] AS ' SUM
(GENERATE(HIERARCHIZE(DISTINCT({[Store].[Store
City].[Salem].CHILDREN})), HEAD(INTERSECT(HIERARCHIZE(DISTINCT(
{[Store].[Store City].[Salem].CHILDREN})),
ASCENDANTS([Store].CurrentMember)))))' , SOLVE_ORDER = 10001

SELECT { CrossJoin({[Time].[Year].[1997]},{Measures.[Profit]})} ON
COLUMNS , {[Store].[Store City].[Salem].[Store 13], [Store].[-Sub
Total]} ON ROWS FROM [Sales]

I get the following error

<FaultCode>1198822294</FaultCode>

<Description>Formula error - cannot bind: unknown member:
"[Store].[-Sub Total]"</Description>

which means that I can not access the Sub total member I created on the
first level,
is there any work around in this situation, how can i create new
members accessible in this scenario, it wont allow me to create member
on [Store City] level.

Thanks