Skip to Content

BI Query Java Web setting in Portal/BW

Hi Experts,

When we display BW query in CRM Web UI it is directly taking us to Query result and it is not displaying the initial variable screen.It is taking default values of variable screen.

In general before executing the query it shoudl dispaly the variable screen in web analyzer.

If any one come across this kind of problem.we are using CRM 07 WEB Ui to dispaly BI7.0 Queries.

In Prodcution environmet itcan cause timeout errors becuase of high volume of data.

Do we need perform any sttings in BI for Java Web components of BI query.

.Regards

Venkatesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Feb 22, 2010 at 09:49 AM

    Check if you are passing parameters and what is the Query String URL used in your iView?

    Chintan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2010 at 07:11 AM

    Hi Prasad,

    Please check the below link which might be of some help.

    Displaying variable entry screen in BEx Web application iview

    Thank You.

    Regards,

    Murthy.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Murthy,

      Thank you for the quick response, The blog explains how to create an iView in portal to get.

      But my issue is not to create, I have already created the iviews and displaying them.

      When I execute the query in portal its taking me directly to result set with out variable selection screen.

      The above symptom is not advisable when there is a variable manual selection required to execute the BI query.

      Thanks & Regards,

      Venkat.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2010 at 03:52 PM

    PRASAD,

    go to query designer and under the default values tab double click on the characteristics and define a variable there. save the query, and now create a new iview and you should see the selection screen. remember, when you define the variables in the query designer and save it gets saved in the BI database. now creating an iview out of this will call the query stored in the BI database and then present the BI report on the iview....hope that helps...

    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.