none
Excel 2013 MDX

    Question

  • I have a custom report in Excel 2013 that utilizes the Cubeset, Cubemember, and Cuberankedmember functions.  (We are specifically staying away from PowerPivot as the layouts do not meet our business needs).

    For the most part, this is working wonderfully.  However, I have a few measures that are returning unexpected results.  What I'm trying to figure out is what is the MDX that Excel is running under the covers to get these results.  If I could see that I could troubleshoot my problems and possibly fine tune the way I am retrieving data.

    Are there any references out there that tell me what a Cubemember function equates to in MDX?  I've searched and searched and searched....

    Thanks,
    Stephanie

    Thursday, June 20, 2013 3:51 PM

Answers

  • Hi Stephanie,

    The "CUBEMEMBER()" function returns a member or tuple from the cube. For example:
    =CUBEMEMBER("Connection","[Date].[Fiscal].[Fiscal Year].&[2004]")

    The expression equal the following MDX query:
    SELECT [Measures].[Internet Sales Amount] ON 0,

    [Date].[Fiscal].[Fiscal Year].&[2004] ON 1

    FROM [Adventure Works]

    So, could you please elaborate more information about the unexpected result in your Excel? Maybe you can try to recreate the report to see if this helps.

    If you have any feedback on our support, please click here.

    Best Regards,


    Elvis Long
    TechNet Community Support

    Saturday, June 22, 2013 1:55 AM