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.


    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

    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


All replies