Hi, experts.

I'm working on Analysis Services cube names Sales. Two dimensions in this
cube is: Data and Store. Stores number is increasing every month. My tasks
is 1) to calculate the sales growth per period and 2) to calculate sales
growth but not including the stores opened after previuos period. The first
task is easy to implement - Created a calc member
([Measures].[Sales Retail], [Date].currentmember) - ([Measures].[Sales
retail], [Date].prevmember)

But how to deal with another option? I need to include only stores, opened
before Date.prevmember. In Stores dimensions there are member properties
called "store opening date". The nicest option is to have dimension: All
Stores/Only Old stores or add a new calc member wich should exclude the new
stores.

Is there any solutions or tasks like this done before?

Thank in advance

Ramunas Balukonis