cancel
Showing results for 
Search instead for 
Did you mean: 

Ad Hoc Query Designer - Web Application

Former Member
0 Kudos

Hello,

I have created a Web application that has the 'Ad-Hoc Query Designer' item.

When I go to create a new query I don't have the option (or I can't find it) to use any variables.

Like in Analyzer I can run a query and it will ask me the values for the variables I have embedded in the query.

How do I make that work using the 'Ad-Hoc Query Designer'

Also I have problems with the application timing out, what timeout variable needs to be adjusted?

Thanks,

Nick

Accepted Solutions (1)

Accepted Solutions (1)

emjay
Active Participant
0 Kudos

You have to run the Launch query in browser from the query designer window, it will be the second icon from the top. This will open up the query in a browser and if the query has a selection screen the browser will launch the selection screen.

For the application timing out, it is a parameter that has to be set in the instance profile of the BI application server. You can ask your basis team to increase the parameter 'rdisp/j2eetimeout'.

Hope this helps

EmJay

-


Assign points if helpful

Former Member
0 Kudos

I found out that this is a limitation of using the "Ad Hoc Query Designer" You may not use the variables window.

Thanks

Nick

Former Member
0 Kudos

Hi,

At initial screen you can not see the variable screen, however after excecuting that you will be at report screen which has variable button.

by selecting that you can use indirectly Variable screen.

Thanks

Pramod

Answers (0)