- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Parameter related issue while connecting to SAP BW reports that has mandatory parameter selection
Hi,
I am able to connect to cubes in a SAP BW and also able to access data in them. There is a list of predefined BW reports that I want to access for further analysis & dashboard creation purpose. Whenever I tried to access a BW report I present with an error that says
" Parameter.Error: A required cube parameter was not provided ". Please find below the screenshots for the same.
Does anyone know how can I enable/resolve this parameter related issue?
Note: - The report i am trying to access in SAP BW has 3 mandatory parameter selection in SAP BW bex query designer. In other words, if I need to access the report in SAP BW than I need to pass 3 parameters in bex query designer along with other optional parameters to access/view the report.
Awaiting some fruitful inputs.
RegardAccessing a report that has mandatory parameters - 1
Accessing a report that has mandatory parameters - 2
Accessing a report that has mandatory parameters - 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @hemantsingh,
Here is a blog which describes how to use parameter in query, please check if it helps or not.
http://biinsight.com/power-bi-desktop-query-parameters-part-1/
Regards,
Charlie Liao
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-caliao-msft,
My sincere thanks to you for reverting & helping me in resolving the mentioned issue. Further, I have read the article you shared & will share with you the result whether the solution discussed in article resolved the issue or not.
Regards,
Hemant

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-23-2024 05:03 AM | |||
09-19-2024 10:19 PM | |||
10-10-2017 03:49 AM | |||
07-17-2024 09:39 AM | |||
05-23-2024 07:19 AM |