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

Question

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

Saro · Answer

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

Madasamy -Oracle · Answer

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 · Answer

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