Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Sales growth analysis

Author  Topic  Ramunas Starting Member 1 Post Posted - 2006-02-11 : 01:25:14 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