Issue of BI Webservice in BO 4.0 FP3

25 Views

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