Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

report dates parameters not incremented

Accepted answer
14
Views
2
Comments

Hi,

I defined a Data Model, with DATE FROM/DATE TO as parameters, in the following way:

p_date_from: {$SYSDATE() - 7$}

p_date_to: {$SYSDATE()$}

Then I created a report using above Data Model and scheduled it daily, but above dates are not incremented and output is always referring to the original dates.

Please suggest how to fix it.

Thanks

Tagged:

Best Answer

Answers