This discussion is archived
5 Replies Latest reply: Feb 21, 2013 7:40 PM by Srini VEERAVALLI RSS

Presentation Variable in SQL statement -11g

939893 Newbie
Currently Being Moderated
We have one prompt for selecting the date & set 1 presenation variable on that as PV_DATE.
Also we have a rep var as START_DATE which store say a date (1st Jan 2001).

Based on user selection of date we've to provide say TOTAL_SALE between (START_DATE & PV_DATE).

In TOTAL_SALE column we've used filter option on DATE.
Date is between repository variable & presentation variable
Date is between @{START_DATE} and @{PV_DATE}{02/20/2013}

but the SQL automatically changes to:

FILTER("- SALES Facts"."TOTAL SALE" USING ("- Generic Date"."Date" BETWEEN VALUEOF("START_DATE") AND date '2013-02-20'))

what probable mistake are we doing

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points