Drillthrough Access From Assembly (OLAP)

Question

As my experience with OLAP & MDX is somewhat limited I am a little foggy as to how to best solve this problem. And any insight is more than welcome.

Here is the situation: I have an .Net Assembly in SSAS2008 which takes a Set SETA from the Query and returns a value.

Ergo:

WITH MEMBER QuartileZ AS MDXQuartile!Percent25(SETA,Parameter,0.25)

SELECT QuartileZ on 0, [Time].[2010].MEMBERS on 1 FROM CUBE_A

My problem is I need to perform a drillthrough on SETA.

So here is my question:

Is it possible to perform drillthrough from the codebehind ,for example:

public string Percent25(Set _Set,Expression _inputExp, double Percentile)

{/// Get drillthrough data on Measure _inputExp over _Set }

OR is there a way that one could write a sub-query which would return the desired drilldown data to acheive this

WITH MEMBER QuartileZ AS MDXQuartile!Percent25(DRILLTHROUGH SELECT SETA FROM CUBE_A RETURN [$Parameter] , 0.25)

I have already looked into Mosha's Drillthrough on calculated measures  

http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx

But that approach unfortunately will not meet the needs of this project. how could one access drillthrough from within an assembly?Any help, suggestions, or assistance is greatly appreciated.

- B_Allen

Answer 1

This sounds very interesting.  I found a document related to this, could you check if that helps? 

http://msdn.microsoft.com/en-us/library/aa140054(office.10).aspx 

Answer 2

You can use MDX Drill through statements, for more details,check BOL article;

http://technet.microsoft.com/en-us/library/ms145964.aspx

Even by using Action class,you can create different actions, check BOL article for more details;

http://technet.microsoft.com/en-us/library/ms345086.aspx#Action

---

Ani

Answer 3

Hi,

If the above links do not help, you may want to open a support case with a sample for us to investigate.

Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

Thanks,

Cathy Miller

Microsoft Online Community Support