mariushn's avatar
mariushn
Regular Visitor
8 years ago
Status:
Needs Info

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's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity 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 

  • mariushn's avatar
    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'

     

     

    Best

    Marius