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.
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]
1 person found this helpful
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.
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.