Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

SAP BW Connector MDX - Technical parameter names change

Hi there,

 

since a couple of weeks the technical names of the parameters in the variable entry changes in the MDX code of my SAP BW queries. The technical name is not the name which is maintained in SAP BW and the concerning query.

 

Example:

{Cube.ApplyParameter, "[!V000007]", {"[ZDIVID].[BRIO]"}}}),

The red marked text is the name of the parameter which changes always the name and lets to the abort ot the data load in PBI.

 

Why isn't PBI using the technical names of SAP BW like for the characteristics and the key figures?

Example:

{Cube.AddAndExpandDimensionColumn, "[0CALYEAR]", {"[0CALYEAR].[LEVEL01]"}, {"Calendar year.Calendar year Level 01"}},

{Cube.AddMeasureColumn, "GS value acc. (BU)", "[Measures].[00O2TJS9VQMW2LNGA7E6GYQ5Z]"},

 

Best regards.

Marius

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @mariushn,

 

>>since a couple of weeks the technical names of the parameters in the variable entry changes in the MDX code of my SAP BW queries. 

 

Did the issue happen in desktop or service? Was there any change in desktop/service/ report since couple of weeks? 

 

>> {Cube.ApplyParameter, "[!V000007]", {"[ZDIVID].[BRIO]"}}}), The red marked text is the name of the parameter which changes always the name and lets to the abort ot the data load in PBI.

 

Which parameter name is defined on SAP BW side? Would you please share some screenshots to show how you get data in desktop? 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
mariushn
Regular Visitor

Hi,

 

the issue happens in the Desktop version and the PBI services.

 

This is the BW Parameter 'Z1_DIVISIONID_S_O' of the InfoObject ZDIVID. The value of the Variable is 'BRIO'

 

ss1.PNG

 

Best

Marius

mariushn
Regular Visitor

@v-qiuyu-msft is there any new information?