Forum Discussion
SAP BW BEx Dynamic Parameters
Hi Anonymous,
You can follow below blogs to use query parameter in M query.
Power BI Desktop Query Parameters, Part 1
Power BI Desktop Query Parameters, Part2 – Dynamic Data Masking and Query Parameters
Regards,
Yuliana Gu
We try to use Bex Exit variables for time. I would rather control all the dynamic things in one place, Bex. Then all the tools we have run the same way if using the same query. We setup YTD/QTD/MTD ranges as exits and I build out preconfigured measures based on this.. ie YTD Sales $, YTD Order Qty... Sales Today, Sales Yesterday, YTD PYr.. etc. and let the backend do all the work. Coming from BOBJ tools, PBI doesn't play well with BW.
james
I have to conclude that SAP doesn't expose BW to other vendors such as Microsoft, Tableau the same way it does to other SAP applications including SAP BOBJ, since we have no issues doing this basic stuff in SAP Business Objects. I don't want to pull in years of data into Power BI and then let the user slice and dice within this data set. It should rather be dynamically controlled at run time. Thanks for all of the replies!!
You may want to start a new post and see if you can get some better answers. I will agree that no one other than SAP plays nice with SAP. We tried Tableau 5 years ago and that was a disaster and have been using Power BI for about 4 years without any issue. However, we were not a mature company with a lot of BEx reports or BOBJ development. So for us we build as much as we can in our BEx query and then typically just have Power BI pass in the date filters. We also use Power BI to create dashboards (charts/graphs) and not for table based reporting, anything users need in table form or excel still go through BEx Analyzer.
Good luck!