Hello,

In the cube I have a Dimension Shops

Shop 1
Shop 2
Shop N

I have created a calculated member like:

ProfitAllShops:

SUM([Shop].[ID].AllMembers, [Measures].[Profit])

Shops may not see the profit of other shops,
so I want to make a local cube for every shop.

but when I do that the ProfitAllShops calculated member is the
same as the shops profit.

Is there a way to generate a local cube with Shop Dimension items like

Shop 2611 24.550 euro
Other Shops 354.300 euro
All Shops 378.850 euro

Thanxs in advance,

Chris









Now I want to create a local CUBE for every shop