SAP BW variable input not working

[admiraldata]

We are connecting PowerBI to SAW BW, and are facing an issue on many queries where the query parameter does not show up for selection in PowerBI.

Example query is below – where you can see that in BeX (SAP reporting tool), the Ledger is a required field and you can select values.

However in PowerBI, ledger does not come up for reporting, and even if we put in the actual value it doesn’t work.

I've seen https://community.powerbi.com/t5/Desktop/SAP-BW-variable-input-not-working/m-p/84545#M35427 but it doesn't seem to be the same issue. Anyone else encountered this issue?

[v-haibl-msft]

@admiraldata

If you are using the latest May 2017 version of Power BI Desktop, could you please enable product tracing on the diagnostics tab of the options dialog and to capture a trace while perform the repro steps? Then upload the trace logs to online file service like OneDrive and share to me.

Best Regards,
Herbert

[PowerBIStudent]

Hello @admiraldata

Could you please share the details about how did get this working?

Would appreciate an detailed resonse.

Thanks,

PowerBIStudent

[admiraldata]

@v-haibl-msft - how do I share this with you in a non-public manner?

@PowerBIStudent - I haven't gotten it working.

[v-haibl-msft]

@admiraldata

You can send the sharing link through private message to me.

Best Regards,
Herbert

[admiraldata]

 @v-haibl-msft - shared on private message.

[PowerBIStudent]

Hello @v-haibl-msft, @admiraldata

I am curious about - how did you shared details through private message.

Haven't done it earlier.

Thanks,

PowerBIStudent

[admiraldata]

@PowerBIStudent - it's not that intuitive - but when you're signed in, there is a messages sub menu shown just above the topic. Go into that, and send a message allows you to do private messaging.

[v-haibl-msft]

@admiraldata

The traces do not contain any calls to retrieve members for the 0P_AP_LEDGER variable. The release version of PowerBI only supports getting values for Characteristic variables.

For further investigation, could you please execute the following BAPI using transaction SE37 and send us the output?

BAPI: BAPI_MDPROVIDER_GET_VARIABLES

With:

CAT_NAM = '0FIAP_M30'

CUBE_NAM = '0FIAP_M30/Z0FIAP_M30_AGE_Q0001_2'

Best Regards,
Herbert

[mariushn]

Hi,

you need to add the InfoObject 'Ledger' to the 'free characteristics' in your query. Then the values will appear in the variable entry in PBI!

Best regards.

Marius