Skip to main content

    Power BI

    New

    member properties ssas

    Vote (116) Share
    Diederick's profile image

    Diederick on 23 Feb 2016 15:28:32

    Currently it's not possible to show the member properties of a dimension. For creating reports some of the metadata is stored in member properties and needed for reporting questions.

    Comments (15)
    Diederick's profile image Profile Picture

    bb453649 92fa-450a-a16d-63e4a234ea5f on 05 Jul 2020 23:18:44

    RE: member properties ssas

    The Cube.AttributeMemberProperty M function is poorly documented and does not seem to work at all.

    Please either provide valid examples of use - ex with intrinsinc member properties - or fix this function.

    In my context, multidimensional cubes are the main source of data for Self-Service BI users, and we need PowerQuery to better handle this source type.

    Diederick's profile image Profile Picture

    cce713af 3cfc-41cd-b147-e9ecef59c988 on 05 Jul 2020 23:18:28

    RE: member properties ssas

    up

    Diederick's profile image Profile Picture

    8f0f3dfa 2cb2-408f-b949-09521e370a15 on 05 Jul 2020 22:40:59

    RE: member properties ssas

    You can access member properties by using a direct MDX query, although this is not suitable for non technical staff.

    Diederick's profile image Profile Picture

    855076b3 7284-4d31-b3c4-8e8c76593fa8 on 05 Jul 2020 22:28:59

    RE: member properties ssas

    Showing properties would tie in nicely with tooltips, at least in our case.

    Diederick's profile image Profile Picture

    5de323e5 f51c-40f9-99d2-3d2797b28f44 on 05 Jul 2020 22:22:25

    RE: member properties ssas

    I have Latitude/Longitude information as member attributes of a level of a geographical hierarchy and I can't seem to expose them to the map Lat/Long fields in PowerBI desktop. The ability to do so would be very convenient.

    Any ideas?