MDX WHERE clause don't work
Hi,
I am having problem with MDX query, I am not sure if the procedure is right or wrong !
CREATE MEMBER CURRENTCUBE.[Measures].For_Gross_Sales AS (
SELECT NON EMPTY [Measures].[Gross Sale] ON 0
FROM [Measures]
WHERE ([Data Type].[ID].[ID] = 2 AND [Chain].[Customer ID] = [Measures].[Customer ID]),
VISIBLE = 1 , DISPLAY_FOLDER = 'Forecast' , ASSOCIATED_MEASURE_GROUP = 'Data Types';
Bellow is the case; I have 3 dimensions(Datatype, Customer, Product) and one measure (GrossSales). so what will be the MDX query if I want GrossSales for ProductID = 1,2,3 and Dataype = 4,5,6 ? Here Datatype has relationship with GrossSales, Customer has relationship with GrossSales and Product has relationship with Customer. if you please help me. thanks in advance!
thanks
|