Tuesday, May 15, 2012 3:22 PM
Hello, I have to come up with a way to pass a set of data to a custom aspx page. The users will browse the cube via excel and then a custom action will pass its "location" to this page to allow some updates to the underlying datasource tables.
One of the things I'd like for this page to except will be the WHERE clause of the already defined drillthrough action for a measure. So I envision the querystring of the url to be something like so:
somepage.aspx?MDX=([Measure.Error Count], [Employee].[Name].&[Doe, John])
For the drill through like this:
DRILLTHROUGH MAXROWS 1000 SELECT FROM [SomeEmployeeCube] WHERE ([Measures].[Error Count],[Employee].[Name].&[Doe, John])
I have the drillthough actions ironed out I just want to be able to grab that MDX based on whatever measure is clicked to pass its MDX. Then the aspx page would display those detail rows via the drillthrough query.
Can someone help with this? I'm very good at TSQL... not so good at MDX. Trying to get better though.
Tuesday, May 15, 2012 4:43 PM
One possibility is that you could use the FindCurrentTuple() function available in the AS Stored Procedures project, http://asstoredprocedures.codeplex.com/.
...unless you already know what attribute hierarchies are going to be on your axes in which case you'd just use the CurrentMember function on those attribute hierarchies to assemble a string representation of the current tuple.
- Marked As Answer by petesman Tuesday, May 15, 2012 6:22 PM