member properties ssas
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.
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.
Tony DeFelice commented
You can access member properties by using a direct MDX query, although this is not suitable for non technical staff.
Mads Berge-Lind commented
Showing properties would tie in nicely with tooltips, at least in our case.
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.