BI Publisher (MOSC)

MOSC Banner

Data Model using Answers Logical SQL doesn't work with Date Parameters

edited Dec 2, 2019 1:32PM in BI Publisher (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center