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
4 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:NewtoNeeds Info - mariushnRegular 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'
Best
Marius
- mariushnRegular Visitor
v-qiuyu-msft is there any new information?