Forum Discussion
dabratt
8 years agoFrequent Visitor
[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...
dabratt
8 years agoFrequent Visitor
Spoiler
Hi,
I'm trying to display in Power BI a dimension calculated member created in SSAS MD.
It works fine when the dimension has a single attribute.
But it should also work if the dimension has several attributes as stated here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/#capabilities-and-features-of-ssas-md
=> must be a single real member when the dimension has more than one attribute
Whatever i'm trying, it is not working.
For exemple, adding this member in the AdventureWorks cube does not work on the Power BI side:
Am i missing something ?
Thanks.
I'm trying to display in Power BI a dimension calculated member created in SSAS MD.
It works fine when the dimension has a single attribute.
But it should also work if the dimension has several attributes as stated here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/#capabilities-and-features-of-ssas-md
=> must be a single real member when the dimension has more than one attribute
Whatever i'm trying, it is not working.
For exemple, adding this member in the AdventureWorks cube does not work on the Power BI side:
CREATE MEMBER CURRENTCUBE.[Date].[Month of Year].[LastDateDesVentes]
AS TAIL(
NONEMPTY(
[Date].[Date].[Date]
,[Measures].[Sales Amount]
)
,1
).Item(0), VISIBLE=1 ;
Am i missing something ?
Thanks.