none
Drillthrough Access From Assembly (OLAP) RRS feed

  • 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

    Monday, January 17, 2011 6:47 PM

Answers

All replies