|
Subject:
|
Problem in calculating total sales in MDX query
|
|
Posted By:
|
jaee
|
Post Date:
|
3/9/2007 10:10:35 AM
|
hi,can someone please help in finding the error in this mdx query for the given problem statement.
Query : Sales performance by gender of the customers.
- The expected output is 2 values of sales ,one for all male customers and other for all female customers.
- The level CustomerID of dimension Customer has attribute GENDER.
- I have calculated two sets [Male] and [Female] .
- At present i am getting sales value for all the members ,i want one aggregated value for male set and another value for female set.How do i go about doing this???Please help.
MDX Query :
WITH set [Male] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "M")'
set [Female] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "F")'
SELECT {[Measures].[SALES($)]} ON AXIS(0), {[Male],[Female]} ON AXIS(1) FROM [cubename]
|
|
