Problem with roles and querys

[diegoi]

I having proving roles permissions with differents querys, and I found this problem. I set the roles permission for members from a dimension named as 'Merchants'. This is the configuration:
<Role name="California manager">
<SchemaGrant access="none">
<CubeGrant cube="Sales" access="all">
<HierarchyGrant hierarchy="[Merchants]" access="custom" topLevel="[Merchants].[Merchant Name]">
<MemberGrant member="[Merchants].[Subway - Plaza America]" access="all"/>
<MemberGrant member="[Merchants].[Subway - M St at 21st St.]" access="all"/>
<MemberGrant member="[Merchants].[Subway - Old Ox Road]" access="all"/>
<MemberGrant member="[Merchants].[Subway - South Lakes]" access="all"/>
<MemberGrant member="[Merchants].[Subway Elm Street, McLean]" access="all"/>
<MemberGrant member="[Merchants].[Subway Fair Lakes]" access="all"/>
<MemberGrant member="[Merchants].[Subway Greensboro Dr, Tysons]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
When I do a query without the merchant dimension, using others dimensions (Area,Products for example), my query brought only the washington area (when I do a query with merchant, brought more areas). It seems tha brought me the first area and nothing more
This is my query with merchant dimension: (this query works fine, brought five or six areas from diferents merchants)
select non empty {ClosingPeriod([Time].[Month],[Time])} on columns,
non empty Crossjoin({[Areas].Members},{[Merchants].Members}) ON rows
from Sales
without merchant (this only brought the washington area)
select NON EMPTY {[Time].[All Times].[2005].[September]} ON columns, NON EMPTY {[Areas].[All Areas]} ON rows
from [Sales]

[bennychow]

When Merchant dimension is not on the rows or columns axis, the Merchant dimension will slice by the default or first available member. In this case, it's probably your Washington member. If you intended to aggregate across all accesible merchants than you need to create a calculated member and slice on that. Ex.
with member [Store Type].[All Store Types].[Custom Group] as 'Aggregate({[Store Type].[All Store Types].[Deluxe Supermarket], [Store Type].[All Store Types].[Gourmet Supermarket]})'
select {[Measures].[Warehouse Sales]} ON COLUMNS,
Hierarchize(Union({[Product].[All Products]}, [Product].[All Products].Children)) ON ROWS
from [Warehouse]
where ([Store Type].[All Store Types].[Custom Group], [Time].[1997])