Bex Variable in BI web service

[Former Member]

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

Regards

Karthik

[Former Member]

It is Bug in SP10, Fixed in Sp12

[nikhil_joy2]

Hi Karthik,

Ensure that BI Service input parameter refresh is set to true (default value being false) to request document to be refreshed upon web service invocation. If it is false, prompts are internally solved with last selected values for document automatically ie values when document was last refreshed and saved.

Also best practices recommends report filter instead of query filter. So try to create  prompts on top of  webI report and use it in web service. If you are still getting error messages, please post the error message here.

Regards,

Nikhil Joy

[Former Member]

Hello Nikhil,

Thanks for the reply. I alread changed the refresh parameter. However, the refresh parameter comes into picture after generation of wsdl url.

For example, if we have a web i prompt. The wsdl would have input condition saying "prompt, value, operator" (which we bind to cell in xcelsius for passing). Also in the process of creation, the wizard will show you all the available web i prompts. But this is not happening for Bex prompts.

In my case, I cannot avoid Bex variables , as i am defining a DSO report and the key figures are dependednt on User Input.

Now  i am forced  to go back to 3.1 methods.

as QAAWS - Not supported over BICS ( only Universes)

Live office - Bex variables are not supported

Bi services - Bex variables are not supported.

I am sure many might face this situtation, as it is very common to leverage prompts from Bex to BO. can anone throw some light on how you resolved this.

Regards

Karthik