Analytics Software

Hi everyone,

I've got a dashboard page with 2 dashboard prompts. I want to set the default of the second prompt equal to a SQL query which uses a presentation variable set in the first prompt.

Let's say Dashboard prompt 1 sets CUST_ID_PRES_VAR

Then Dashboard prompt 2 should default to SELECT MIN(TRANS_DATE) FROM CUSTOMER_TRANSACTIONS WHERE CUST_ID = '@{CUST_ID_PRES_VAR}'

However, when I hit the test prompt button the default is blank. When I look at the SQL issued in the log file, it hasn't interpreted the presentation variable, but instead sent out the literal string CUST_ID = '@{CUST_ID_PRES_VAR}'.

Is there anyway to force OBIEE to interpret presentation variables within a SQL select statement?

thanks for the help!

-Joe