Data Model using Answers Logical SQL doesn't work with Date Parameters
Hello,
I was trying to create a Data Model using the "Oracle BI EE" Data source. Here I entered a Logical SQL and tried to define a Date From and Date To parameters to limit data.
The Logical SQL has the following form:
select
"Sales"."Fact - Sales"."Sales USD"
....
FROM
"Sales"
WHERE
(
(
"Invoice Date"."Date" BETWEEN DATE '2015-01-01' AND DATE '2015-01-15'
)
This Logical SQL was retrieved from an Analysis with hard coded dates in the filters.
I changed the hard coded dates to :p_from_date and :p_to_date but the "Edit Data Set" window where you enter the sql does not accept it.