4 Replies Latest reply: Mar 4, 2013 1:18 PM by Srini VEERAVALLI RSS

    Is it possible to pass Presentation Variable into SQL code?

      Is it possible to create a Prompts that can pass data inputted in the Prompt to a SQL statement?


      User inputs
      Dashboard Prompt: Date Between today date AND yesterday's date

      Which pass information to a measure and labels the the information:

      CASE WHEN "Date.Datetable" = {@}DATE1 THEN 'Today' Else 'Yesterday' END FROM "TABLE_Example"