Hello,

Let's say there is a cube with dimensions:
store: country -> region -> store
time: year -> quarter -> month
product: productgroup -> product
and measure:
sales

I'd like to create a calculated member in the olap cube which gives me
the measure 'sales', but excludes the sales for store 'A'. So the
measure should dynamically rollup to whichever level I'm at in the
cube and only give sales for all stores but store 'A'.

How can I do this?

Kind regards,
Carlos