Hello,

- How do I order the results of a DrillThrough query in MDX based on a field
in the fact table?

- How do I limit / filter the results of my drillthrough query based on the
value of a Measure?

I currently have:

DrillThrough
Select
From MyCube
Where (
[Dimension1].[x]
, [Dimension2].[Y]
, [Dimension3].[Z]
)

Now I want only those records that meet the restriction of Measures.[My
Measure] = 1
It so happens that the field in the fact table for that measure is either 0
or 1.

If I were to write a sql query to get the same info

Select * from FactTable
Where DimensionField1 = X_id
AND DimensionField2 = Y_id
And DimensionField3 = Z_id
AND MeasureField=1
Order By SomeField DESC

Any suggestions would be much appreciated.

-Bas