Posts Tagged ‘ MDX ’

Sales performance by gender of the customers with MDX Query

January 18, 2010
By admin
Sales performance by gender of the customers with MDX Query

WITH set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “M”)’ set AS ‘Filter (..Members,.CurrentMember.Properties(“GENDER”)= “F”)’ member Customer.AggMale as ‘Aggregate() member Customer.AggFemale as ‘Aggregate() SELECT {.} ON AXIS(0), {Customer.AggMale,Customer.AggFemale} ON AXIS(1) FROM
Read more »

Tags: ,
Posted in Microsoft, Sql Server 2008 | No Comments »