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.