Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

admiraldata

SAP BW variable input not working

Submitted by on ‎05-02-2017 07:11 PM

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.

ledger1.png

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

ledger2.jpg

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?

Status: Needs Info
See more ideas labeled with:
10 Comments (10 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎05-04-2017 02:25 AM

@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
New Member
‎05-08-2017 08:12 AM

Hello @admiraldata

 

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

Would appreciate an detailed resonse.

 

Thanks,

PowerBIStudent

admiraldata
Frequent Visitor
‎05-08-2017 10:06 PM

@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
Microsoft Employee
Microsoft Employee
‎05-09-2017 07:07 PM

@admiraldata

 

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

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎05-09-2017 07:08 PM
Status changed to: Needs Info
 
admiraldata
Frequent Visitor
‎05-09-2017 08:33 PM

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

PowerBIStudent
New Member
‎05-10-2017 05:31 AM

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
Frequent Visitor
‎05-10-2017 03:33 PM

@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
Microsoft Employee
Microsoft Employee
‎05-11-2017 07:26 PM

@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
Regular Visitor
‎07-19-2017 05:43 AM

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  

Idea Statuses