on 10-16-2008 8:24 AM
Hi,
I am having some difficulties when I was trying to creating Webi reports. It shows error when I tried to fill in the prompts before the query runs. The report data comes from the SAP Business Warehouse. So far it is my understanding for the query flow:
Step 1
SAP Business Warehouse <-- Query A (BW Query) <--
Step 2
BO Universe <-- Query B (By drag & drop) <-- Application(e.g. Webi, QaaWS)
When I run the Query A (using 'Analyzer' in 'Business Explorer') to extract data from BW, the query appears 7 optional parameters for filtering. After I filled some of the fields, the query runs fine -> Step 1 OK.
When I want to do the same thing in a BO approach by building query (i.e. Query B) to draw data from the universe (which points to the Query A in BW) using different applications(e.g. QaaWS, Webi via InfoViewApp, Java Webservice SDK: QueryService & ReportEngine, etc), the application will display 7 optional prompts (i.e. those referring to those appeared in Query A) before the query executes. However, when I tried to fill those prompts, the application appears some fill prompts error and no query job is submitted to the BW -> Step 2 Fails.
When I skipped to fill those optional prompts in building the Query B, the query job can be submitted and the query result is returned.
Before the error occurs, I have been working on building similar Webi report and everything goes fine. I feel so strange that why the error appears so suddenly and I would like to ask how to avoid it.
Many Thanks,
Gary
Hi Adil,
I am using BOXIR3 and a screenshot is attached below:
[http://farm4.static.flickr.com/3200/2948600340_4f1330d283_o.jpg]
I have built the query in InfoView by drag & drop and after I click the 'Run Query' (the circled area), it is expected I will be asked to fill in some optional prompts (from BW query). Instead, an error shown about 2 minutes after clicking the button,.
[http://farm3.static.flickr.com/2004/2947792827_bfacdc7dbe_o.jpg]
Regards,
Gary
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What is the error?
What are the version and patch level applied so far?
Adil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.