SSAS Attributes and Members

[adild2k]

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

[meysun]

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

[Doskamp]

Hi Meysun,

any progress on adding it to Power BI?

Also an option to vote.

Vote: Member properties SSAS

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.

[Doskamp]

Any progress on getting this done? 

Please vote to get this in Power BI.

Vote: member properties ssas

[fbrossard]

Great news!