Hi Experts,
We are using SAP BI 4.2 with over 1000 Webi reports in our system.
We use a lot of optional prompts in our reports and the requirement is to gather information on each report’s prompts filter etc.
Is there any method to retrieve that information ?
kamran.bobj (BOB member since 2011-12-20)
The Webi REST API should be able to get that information. The process would probably look something like;
Iterate over all report objects
For each report object iterate over each data provider
For each data provider iterate of each prompt
Extract information from each prompt
I cant remember if theres another level below that.
Has to be done with a programming language though as you initially need to authenticate to get a bearer token then use that token in all the API calls, and then, again, using a programming language to iterate the API endpoints when necessary.
Further info.
ABILtd 
(BOB member since 2006-02-08)