Skip to Content

Query Panel and connection BICS for BW

Hi Gurus,

I connected a Bex BW query to BO Webi 4.0 through BICS connection.

I notice that when I try to run the Webi's "query panel" it don't appears.

If I go to check the transaction "SM50" in SAP BW I found a process launched with my user as can you see below.

I notice that the Webi's "query panel" appears only if i kill this porcess.

It happens to someone ?

Thx

Best regards.

Rino

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2013 at 12:09 PM

    Hi Gennaro,

    I had the exactly same issue, and took me a long time to find out what was causing the problem.

    I started removing each infoobject from the BW query and going back to the WEBI to see if the performance was improving with less objects.

    I found out that I had ONE infoobject that was causing the long waiting time on webi, and it was the WBS.

    With more debug on what SAP was trying to read during the execution, I found out that most of the time the program was reading the Hierarchy tables from WBS.

    I had multiple alternative hierarchies on that infoobject and some were obsolete.

    I deleted the obsolete hierarchies and the problem was solved.

    My wait time in webi to get the query panel was 30 min+ and after I deleted the hierarchies went to 2 min. (still, it is not 2 seconds, but I can wait 2 minutes...)

    I hope it helps.

    Regards

    Rodrigo Silva

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Gennaro Sica

      Good to know that part of your issue is solved.

      It took me 3 months to find where the issue was (hierarchies), but when I open a SAP message, they mentioned that this will be improved in BI4.1.

      I am at BI 4.0 SP5 and instead of going to SP6 will evaluate BI4.1.

      Regards

      Rodrigo

  • Posted on Sep 23, 2013 at 02:06 PM

    Hello Gennaro,

    - can you run the BEx query successfully in transaction RSRT ?

    - do you have another tool available - for example Crystal Reports, Analysis, BEx Analyzer - just to see if there is a general issue or a pure WebI issue.

    - do you see the WebI process "working" when creating a new report ?

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Gennaro,

      does it not appear at all or only after a very long time ?

      When Web Intelligence is creating a new report it is reading all the meta-data for all the elements that are in the BEx query (rows, columns, free characteristics, key figures).

      in addition it will read all the available attributes and hierarchies for all of those elements.

      Ingo

  • Posted on Sep 20, 2013 at 05:17 PM

    Hi,

    There must be huge volume of data that you are trying to render.

    Try restrict data by mandatory prompts . Also check the records or no.of cells being hit.

    Are there any merged dimensions and the aggrefation on query or report level?.

    Thanks,

    Jothi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2013 at 08:55 PM

    Hii Gennaro ,

    If you try to open the webi report Double click and then going to design mode then you won't be able to access Query Panel hence kindly right click on the webi report and then click " Modify " option and only then you will be able to open and run query panel .

    If still problem persists then kindly upgrade to patch SP05 or higher .

    Regards

    Jeetan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2013 at 05:12 AM

    Hi Gennaro

    You can try as Jeetan said or with Webi Richclient.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2013 at 08:36 AM

    Hi Guys,

    probably I have not expressed in right way, I'm sorry.

    The Issue happen when I try to create a new document in WEBI.

    Pratically I:

    • clicked "new report" (whtite sheet)
    • I choosed the connection BICS
    • I choosed the bex report that i need to point

    now should be appears the query panel, instead the Webi application remains in waiting, at same time a BW process appears in the transaction SM50.

    The only way to make appears the query panel in WEBI is to kill this process.

    Someone have an Idea?

    Thx

    Rino

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hii Gennaro ,

      When you select the query for reporting kindly wait for sometime and as it takes to load query and still if it takes time then kindly check bex query performance in BW RSRT Tcode or you can also use RSRV

      Tcode in BW to check if there are no errors in Bex Query objects .

      Regards

      Jeetan

  • Posted on Sep 23, 2013 at 11:24 AM

    Hi Gennaro ,

    Try placing all the obejcts in BEx query in rows , not in free characteristics.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 24, 2013 at 12:21 AM

    I notice that the OSS note 1752639 talks about an error similar to my issue.

    But I don't understand which are the steps for the solution of issue.

    Best regards

    Rino

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.