Skip to Content
Former Member
Mar 13, 2012 at 07:22 PM

Bex Variable in BI web service


Hello Gurus,

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