Value is not appearing in prompt if its user input is of text field

Saro

Hi friends,

Im in obiee 11.1.1.7.150120

I have a column prompt with a presentation variable p_col_list like below

I have a second variable prompt with the user input as text field and its default selection as sql results(where it brings the value based upon the first prompt @{p_col_list}. The below is my second prompt screenshot

SELECT "3-MP-P2P"."Prompt_List"."col_code" s_1FROM "3-MP-P2P"WHERE (LOCATE("3-MP-P2P"."Prompt_List"."col_name",'@{p_col_list}') > 0)AND RANK("3-MP-P2P"."Prompt_List"."col_sort") = 1

so based upon my first prompt value the second variable prompt has to show the value in its default selection.

Now while testing like below, after the selection of first column prompt value and hitting apply button then the second variable column value has to appear according to the sql that is written. But in my case it is not appearing like below.

But if my second prompt user input is of type choice list and if i give the sql results for the choice list like below

Now if im testing it means, then it is working as it is bringing the value in my second prompt choice list after selecting the first prompt value and hitting apply button like below

But im wondering why the default value in the second prompt, is not working with the user input of text field and it is working with the user input of choice list. How can i make it to work if the user input is of text field for my second prompt. Where could be the issue?

Thanks in advance.

Regards,

Saro

Madasamy -Oracle

Hello Saro,

The Prompts sql queries are executed as soon as they are loaded on the dashboard. You cannot use presentation variable from the first prompt and assign it in sql query of the second prompt. You can use session variables which can be defined in the rpd and populate the values.

I tried the below scenario and that works for me

a. Create two prompts, one which sets the presentation column

b. Second prompt ( in my screenshot, its the bottom one), consumes the presentation variable and use it on the default values.

c. I tried the same on the check box and also the drop down list, both works fine on the default values.

-M

Saro

Hi Madasamy,

I couldnt clearly get with your solution. You meant that i cant use presentation variable and instead do i need to rely on session variable for this text field prompt to work to populate default value based upon the parent prompt selection[where the presentation variable is initialized]

Kindly clarify.

Thanks,

Regards,

Saro

Madasamy -Oracle

its never about session variable.

But as per my understanding, you cant expect a default selection based on a Presentation variable to be available on the prompt where it is set using a column prompt.

Hence, you need to have two separate prompts, one to set and one to consume ( text variable prompt consuming the presentation variable).

BTW, i created a doc and already passed you on.

Saro

Hi Madasamy,

Do you mean that i need to have my child prompt as a seperate prompt instead of having that along with the parent prompt?

If i have my child prompt as a seperate prompt means, then the value can pass from my parent to child prompt, but the report which uses child prompt will not get the value from the child prompt, because once the child prompt received the value then i need to refresh the page or i need to hit the apply button related to my child prompt.

Is this is the only case or is there any alternative soln. Did you get my point.

Thanks,

Saro