Skip to Content
avatar image
Former Member

Failed to fill the prompts when creating Webi Report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 17, 2008 at 02:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2008 at 07:57 AM

    Hi,

    What is the error?

    What are the version and patch level applied so far?

    Adil

    Add comment
    10|10000 characters needed characters exceeded