Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

question about MDX Filter

Status
Not open for further replies.

saulat78

Programmer
Jul 31, 2003
1
PK
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top