show default date value based on another text column prompt value in obiee11g

Devarasu

Hi All,

I have requirement like below,

If user selected Time Series column prompt value as “General ES/VaR” then date column need to be shown default value as “17 Jul 2015" and if they  selected Time Series column prompt value as  “Total ES/VaR” then need to show max date value. if you have any idea/suggestions to resolve this issue please let me know. Thanks

Tried with below steps,

1) Created dashboard prompt and added time series column (defined pv value as "varongrp")

2) created static repository variable STATIC_DATE value as '2015-07-17'

3) added Date column into dashboard prompt and

placed below query at dashboard prompt – date column default selection –  SQL query option

select (case when '@{varongrp}{Total ES/VaR}'='Total ES/VaR' then MAX("Fact"."Date")

when '@{varongrp}{General ES/VaR}'='General ES/VaR' then VALUEOF("STATIC_DATE") end) from "Subject Area"

also tried like below as well

Select (case when '@{varongrp}{Total ES/VaR}'='Total ES/VaR' then MAX("Fact"."Date")

else VALUEOF("STATIC_DATE") end) from "Subject Area"

Note: Time Series has only two values (General ES/VaR & Total ES/VaR)

Thanks

Deva