Forum Discussion
SSAS Attributes and Members
HI Team,
After connecting SSAS (Multi DImensional Model - MDM) with Power BI in a LIVE mode, i am having some issues with respect to attributes and their sorting in terms of calculated members.
I have a utility dimension called "Time Flow" which contains "Actual", "LY Rebase" and calculated member called "Growth (%)". The way PowerBI shows the members in the sorted order i.e., "Actual", "Growth (%)" and then "LY ReBase" which is not right, it should be "Actual", "LY ReBase" and then "Growth (%)".
Secondly, it shows a "Total" column for the "Time Flow" dimension at the end as shown in the snapshot below, which is not right, since "Is Aggretable" property is set to "None" and "Actual" member is set as a "Default" Member at the type of Dimension setup in the cube.
Lastly, not the least, "Growth (%)" member doesn't retain the formating which is being set in the cube at the design time, it should be a percentage instead of showing in a raw decimal value.
Regards
Adil
4 Replies
Support for Non aggregatable and formats set in model are coming soon. We are working on these features.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/ lists the currently supported and not yet supported features
Great news!
Hi Meysun,
any progress on adding it to Power BI?
Also an option to vote.
Member properties are used for detailed reporting with the cube. The are related to an attritbute in the dimension, most of the time the Key attribute of the dimension. These member have much less overhead cost for the performance of the cube because no aggregations need to be done on them.
Example, description fields, date fields (which are not related to date dimension), user, etc.. etc.. detailed information.
