Hi guys,
I am new to MDX, well what I am trying to do is get those Product.Teams whose Measure.Sales is greater then 110000000 in the Time.year.2002 in every Market.country.Pakistan.MEMBERS, (i.e Regions) I hope u guyz better understand by this way
SELECT { CrossJoin({Market.Country.[Pakistan].CHILDREN}, CrossJoin({Measures.[Sales]},{Time.Year.[2002]}))} ON COLUMNS,
{
Filter({Product.Team.MEMBERS}, (((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.Central) > 110000000) And (Market.country.Pakistan.North,Time.Year.[2002],Measures.Sales) > 110000000)
And ((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.South) > 110000000))
} ON ROWS FROM [Sales]
I wrote this MDX successfuly, the problem is the search condition where I can't use the MEMBER keyword, and I have to write explicitly every MEMBER of the region level of Market dimension with the whole condition again and again with the AND operator; like I wrote
(((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.Central) > 110000000) And (Market.country.Pakistan.North,Time.Year.[2002],Measures.Sales) > 110000000)
I know I can't use
(((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.CHILDREN) > 110000000)
but is there any alternative way to do this, cuz here there are only 3 regions IF I got 20 or 25 (Regions) MEMBERS it will be a very long and complex MDX.
I hope you ppl understand wot i m trying to say.
Help needed.
Thanks
Saulat
I am new to MDX, well what I am trying to do is get those Product.Teams whose Measure.Sales is greater then 110000000 in the Time.year.2002 in every Market.country.Pakistan.MEMBERS, (i.e Regions) I hope u guyz better understand by this way
SELECT { CrossJoin({Market.Country.[Pakistan].CHILDREN}, CrossJoin({Measures.[Sales]},{Time.Year.[2002]}))} ON COLUMNS,
{
Filter({Product.Team.MEMBERS}, (((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.Central) > 110000000) And (Market.country.Pakistan.North,Time.Year.[2002],Measures.Sales) > 110000000)
And ((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.South) > 110000000))
} ON ROWS FROM [Sales]
I wrote this MDX successfuly, the problem is the search condition where I can't use the MEMBER keyword, and I have to write explicitly every MEMBER of the region level of Market dimension with the whole condition again and again with the AND operator; like I wrote
(((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.Central) > 110000000) And (Market.country.Pakistan.North,Time.Year.[2002],Measures.Sales) > 110000000)
I know I can't use
(((Time.Year.[2002],Measures.Sales, Market.country.Pakistan.CHILDREN) > 110000000)
but is there any alternative way to do this, cuz here there are only 3 regions IF I got 20 or 25 (Regions) MEMBERS it will be a very long and complex MDX.
I hope you ppl understand wot i m trying to say.
Help needed.
Thanks
Saulat