Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timestampadd function invokes default parameter value rather than presentation variable value

3713479Sep 17 2019 — edited Sep 20 2019

I previously was notified that I am using an obsolete version of OBIEE(11.1.1.7). The request to upgrade to 12C was submitted.

In the interim, may I ask for ideas on why the filter shown below is executed with the default value in the argument list(2010-11-11) rather than the presentation variable default defined in the catalog object( 2019-04-01).

The presentation variable is populated with the 2019-04-01 value and appears in the dashboard page, but that value is not used in the query.

"CCRS Activity Monthly"."Activity Date" > TIMESTAMPADD( SQL_TSI_MONTH, -6,@{PV-START}{DATE'2010-11-11'})

Thanks for any insights...

Added on Sep 17 2019

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

10 comments

607 views