Forum Discussion

blairzy1's avatar
blairzy1
Frequent Visitor
9 years ago

SAP BW connector invalid MDX command

I'm using: Power BI Desktop (April 17 release) I'm trying to connect to SAP BW using the now standard SAP Business Warehouse server connector. SAP NW RFC SDK 7.20 downloaded and extracted. The .lib a...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi all,

 

Please check below information from PG:

 

The generated MDX is this:

 

EXECUTE MDX |WITH MEMBER [Measures].[Microsoft.Mashup.Engine.NullMeasure] AS null SELECT [Measures].[Microsoft.Mashup.Engine.NullMeasure] ON 0,[0PLANT].[LEVEL01].ALLMEMBERS PROPERTIES MEMBER_CAPTION,MEMBER_UNIQUE_NAME ON 1 FROM [ZTAX_REG/REP_20120526_VATREG_TS_GST] CELL PROPERTIES VALUE| WITH-OPTIONS(IgnoreEmptyResultset=true, USEFLATTENING=TRUE);

 

It turns out that "AS null" works correctly on some BW servers but not others.. As of the June release, we will generate different MDX that will avoid this problem, which should fix the issue.

 

Best Regards,
Qiuyun Yu