Forum Discussion

dabratt's avatar
dabratt
Frequent Visitor
8 years ago

[Live connection on SSAS MD] Dimension calculated members issue

Hi,   I'm trying to display dimension calculated members created in SSAS MD.   As stated here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/#capabiliti...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi dabratt,

 

The issue in your scenario should be the [Date].[Date].[Date] is a key attribute. Please verify it on SSAS side. 

 

 

As from here:

  • Dimension Calculated Members (must be a single real member when the dimension has more than one attribute, it cannot be the key attribute of the dimension unless it is the only attribute, and it cannot be a parent-child attribute)

 

Best Regards,
Qiuyun Yu 

dabratt's avatar
dabratt
Frequent Visitor
8 years ago

Hi v-qiuyu-msft,

 

Yes,  [Date].[Date].[Date] is a key attribute.

It works fine when it is the only one attribute in the dimension.

 

If I add another attribute and attach the calculted member to it, I don't see it on the PowerBI side.

 

Regards,

Dabratt.