Issue of BI Webservice in BO 4.0 FP3

[Former Member]

Hi all,

I am exploring on functionality of BI webservice (webi to Dashboard design 4.0 FP3). Data source is BEx query 7.x , which is having one mandatory prompt and six optional prompts. I am not able to pass variables from dashboard to query.

Parameters for getreportblock_xxx:

valueofPrompt -> number,text and date

index             -> empty

refresh           -> true

1. I tried with simple block without any prompt  -  working

2. I tried with report block and one mandatory prompt(numeric) - working

3. report block with one mandatory prompt(text) - not working

4. report block with one mandatory prompt(date) - not working

When i test the BI webservice connection in webi, i am getting error 'Query cannot be prepared'.

I am not able to figure out the issue causing the error.

Please suggest.

Regards,

Kaviraj

[Former Member]

Hello Kaviraj,

I think you should go through the following links to solve your query:

http://www.saptechies.org/usage-bex-queries-via-bics-web-intelligence-4x/

http://www.saptechies.org/web-intelligence-viewer-displays-red-x-where-charts-should/

http://www.saptechies.org/sap-businessobjects-business-intelligence-platform-40-clien/

http://www.saptechies.org/explanation-server-monitoring-metrics-sap-businessobjects-b/

May these links will be helpful to you.

Thank You.

[Former Member]

We have the same BIWS issue. We are running BOE 4.0 SP7 Patch 1.

Has this been resolved or any known workarounds?

[Henry_Banks]

Hi,

It's probably a good idea to try a later version. FP03 isn't maintained any more, and customers should be on SP04 or SP05 because that's where the fixes are ported to for the last 6 months+

regards.

H

[Former Member]

Customer is currently using FP03 only. We are not sure when they will upgrade to SP04 or SP05.

Is there any issue with valueofprompt in BO 4.0 FP03 ?

Regards,

Kaviraj

[Henry_Banks]

the difficulty here is our ability to make an assesment.

this FP03 version was a pre-release "Ramp Up" version, which didn't go "General Availability" ..  it had a few Patches, then was released to GA as SP04+

If you customer is using unpatched FP03, then that is quite serious problem.

[Former Member]

Hi Kaviraj,

Are you able to refresh WebI report?

Are you able to refresh BEx query using BEx analyzer?

What are the prompt values you are passing to mandatory variables in BEx? Text values or Key values

If you are able to refresh BEx query using BEx analyzer then try passing same variable values while testing BI webservice in WebI. The test result should display the output in server response section.If you are able to test the BI service successfully in WebI then only you'll be able to use BI service in Dashboard design.

Regards,

Aashutosh

[Former Member]

Thanks for the quick response.

Are you able to refresh WebI report?

yes, i am able to refresh webi report giving prompt value.

Are you able to refresh BEx query using BEx analyzer?

yes, i am able to use BEx output using BEx analyzer as well.

What are the prompt values you are passing to mandatory variables in BEx? Text values or Key values

the mandatory variable is Fiscal year/period.. optional variables are division,BU and reporting unit etc.,

eg..  valueofprompt  -> 012.2012 (mmm.yyyy)

Currently i am testing the functionality only in webi. I tried the same variable values(which i used in webi prompt and in BEx analyzer) for testing BI webservice in webi. But i am not getting any output in server response section.

i found that its not taking the text value properly. How to pass the text variable? should i need to use any syntax like double quotes or single quotes?

Regards,

Kaviraj

[Former Member]

Hi Kaviraj,

If output in server response section is blank then their is a possibility of passing incorrect prompt values. Click on button "Change to Tree view" present at the bottom of server response. Expand the all nodes, look for the message under "GetReportBlock_xxx". In value column, you'll get details of the error message. You can make use of detailed error message to resolve issue.

Regards,

Aashutosh

[Former Member]

I have already started debugging from the error message in "Change to Tree view".

Here, i am getting empty query error. But i am getting data for same prompt value in webi as well as BEx analyzer. I am not able to figure out whether it is a problem with prompt value syntax?

Regards,

Kaviraj