Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

SAP BW parameter issue while trying to Access SAP BW report

Dear Senior Community Members,         I have established a connection between power BI & SAP BW. I am able to see all the cubes & under them their corresponding reports too. Problem is that i am n...
Need Help
Sokon's avatar
Sokon
Icon for Advocate V rankAdvocate V
9 years ago

Did you find a solution to this? I've got the same problem.

According to the features list of the April 2017 update, there are "enhancements to SAP parameter input experience" with a video that does show no live demo. "enhancements" implies that there was a possibility to define parameters before that update - but where? And there is still no possibility to do that, the screenshots are different to what I see in my current (april) installation. It seems they show a feature that simply isn't there! What am I missing here?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Sokon,

 

    I am on official travel these days. Therefore, didn't get time to check the april update as of yet. I will try to replicate the issue again  at my end & will update you in some time. Further, please check out below things in the meantime.

 

1) are you able to connect to cubes & diff reports in SAP BW separately??  Means, first Try to connect to a cube separately & if you are successful in doing so then try to connect to reports without any mandatory parameters.

 

2) Watch the video on you tube on variable parameter usage in power BI. Try to relate that with your problem.

 

   Write me back the result of above two points. Njoy dashborading.

Regards,

Hemant

Hemant

  • Sokon's avatar
    Sokon
    Icon for Advocate V rankAdvocate V
    9 years ago

    Hi Hemant and thanks for your answer,

     

    I can connect do SAP BW, no problem. I even get data, like, all data from any query that doesn't have mandatory parameters. I can connect to cubes, too (I don't need paramters there, do I?) But I have to use mandatory parameters and want to use option parameters of the query because sometimes you are not allowed to change the source and want to re-use an existing one.

     

    I already know about (report) parameters, as you can learn from the videos. I couldn't find a video about entering parameters for SAP queries.

     

    I startetd another post on this: 

    https://community.powerbi.com/t5/Desktop/SAP-BW-connector-parameter-input-How/td-p/160489

    It explains the problem with screenshots.