4 Replies Latest reply on Mar 4, 2013 7:18 PM by SriniVEERAVALLI

    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"