none
possible to get dimension name of current member in Action? RRS feed

  • Question

  • Is it possible to get the name of the dimension of a selected cell so that I can create a URL based off of it?
    Craig
    Thursday, July 15, 2010 11:59 PM

Answers

  • Hi Craig,

    In [Adventure Works], there is a dimension Product, attribute Category, and the member Bikes. Do you want to return dimension name - Product? I cannot think of any approach to achieve that, because SSAS use implicit current context. Generally, if you query a measure like this:

    Select measures.x on 0 from cube

    The current context is:

    (measures.x, dim1.attribute1.defaultmember,.. … , dim1.attributeN.defaultmember,… …dimN.attribute1.defaultmember,… …dimN.attributeN.defaultmember).

    I mean all the dimensions and attributes are involved.

    Hope some have better solution for this.

     

    Thanks,

    Raymond

     


    Raymond Li - MSFT
    Friday, July 16, 2010 3:15 AM
    Moderator