I am facing an issue with Bi web services. In the process of creating an Xcelsius Dashboard i am follwing the approch of BI web services Bex>BICS>web i> Bi services> xcelsius.
I have two two mandatory prompts in Bex report, which i cannot change as there are Restricted ke figures defined over it. After creating a Web i report over it, i tried to publish the report as web service to feed the data to xcelsius.
When i created a wb service url, i dont see it is getting the prompts (which i need to pass from xcelsius through binding to a cell). I tried to create prompts in web i report on same charectaristic and tried to merge them. but my web i is throwing an error (SQL error) if i do that.
Can someone please share me how to leverage prompts into BI web services.
FYI - we are on BI 4.0 sp2 patch 10