locked
Cant get content of a cell RRS feed

  • Question

  • Hello,

    i use the following formula the get the content of "the name of the shortlink" - 

    =CUBEVALUE("PowerPivot Data";"[Table].[Shortlink]";Slicer_Customer)

    i receive the number 1 instead of the content www.xyz.com - what do i wrong?

    Thank you very much

    Martin

    Monday, March 26, 2018 12:55 PM

Answers

  • Hi Martin,

    Thanks for your question.

    To get content of a cell, please try to use CUBEMEMBER function instead of CUBEVALUE function. CUBEVALUE returns an aggregated value from the cube.
    See below sample code:
    =CUBEMEMBER("._mycube Adventure Works","[Product].[Category].&[1]")
    Above expression will return Bikes as a result.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by krugi Tuesday, March 27, 2018 8:19 AM
    Tuesday, March 27, 2018 2:17 AM