0 Replies Latest reply on Aug 23, 2016 9:30 AM by Devarasu

    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)

      1.jpg

       

       

      Column_prompt_based_another_column.jpg

       

      Thanks

      Deva