To Richard Tkachuk: I love the CellSetGrid, thank you for making it
available. I am attempting to implement DrillThrough callbacks off
clicking the cell values in the UI. I have my callback working on the
click, but I am uncertain about building the MDX for the DrillThrough.
On the callback (in myCallbackEventHandler), I have parsed the
coordinates of the cell (similar to the ClientEventType.Drill case), so
I have a reference to the correct cell in the cellset. My thinking is
that I need to iterate through the axes of the CellSet to get the
unique names for each axis for those coordinates to build MDX something
like this ...
DRILLTHROUGH MAXROWS 1000
SELECT
this.oCellSet.Axes[0].Positions[iMemberOrdinal].Members[0] on 0,
(<Cell definition from each axis>,
<this.oCellSet.Axes[0].Positions[iMemberOrdinal].Members[0].UniqueName>
) On 0

FROM [My Cube]

Is this how you might do it or do you have a suggestion?


Regards,

Tim Heffernan