SELECT {
CrossJoin({Customer.[Customer_Type].[Local],Customer.[Customer_Type].[Upcoun
try]},{Measures.[Sales],Measures.[Last_Sales]})} ON COLUMNS,

{Filter
({CrossJoin({Market.[Country].[Pakistan]},{Product.[Team].[Cardiovascular
Team],Product.[Team].[Feldene Team],
Product.[Team].[Norvasc
Team],Product.[Team].[Others],Product.[Team].[Ponstan Team]})},
[Measures].[sales] > 900000000)}
ON ROWS


FROM [Sales]
CELL PROPERTIES [VALUE],[FORMATTED_VALUE],[CELL_ORDINAL]


The Above Query give a wrong result, the Filter is not working Properly i
think it is only Consider the Measure Value on the ROW axis I want to be on
Both of the Axis. Please Answer it Urgently.

Try using the following on the Row Axis

UNION({Filter({CrossJoin({Market.[Country].[Pakistan]},{[Product].[Team].[Cardiovascular
Team], [Product].[Team].[Feldene Team], [Product].[Team].[Norvasc Team],
[Product].[Team].[Others], [Product].[Team].[Ponstan Team]}),
([Measures].[Sales], [Customer_Type].[Local]) > 9000000000)},

{Filter({CrossJoin({Market.[Country].[Pakistan]},{[Product].[Team].[Cardiovascular
Team], [Product].[Team].[Feldene Team], [Product].[Team].[Norvasc Team],
[Product].[Team].[Others], [Product].[Team].[Ponstan Team]}),
([Measures].[Sales], [Customer].[Customer_Type].[Upcountry]) > 9000000000)}
)

You may want to switch gears and use the NonEmptyCrossJoin function. Then
the UNION statement above can be simplified

{
Filter(NonEmptyCrossJoin({Market.[Country].[Pakistan]},{[Product].[Team].[Cardiovascular
Team], [Product].[Team].[Feldene Team], [Product].[Team].[Norvasc Team],
[Product].[Team].[Others], [Product].[Team].[Ponstan Team]},
{[Customer].[Customer_Type].[Local],[Customer].[Customer_Type].[Upcountry]},
2), ([Measures].[Sales]) >900000000)

HTH
Martin

"Burhan" <burhanist (AT) yahoo (DOT) com> wrote

OK the First MDX is Working Fine
But what if we have More Then 2 Sets does UNION works B/C it takes 2 Sets
Only



"Martin Mason" <martin.mason (AT) earthlink (DOT) net> wrote

rdiovascular
scular
rdiovascular