report dates parameters not incremented

Question

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

MandeepGupta · Accepted Answer

https://community.oracle.com/products/oracleanalytics/discussion/27107/report-dates-parameters-not-incremented

Hi Angela,

Welcome to Oracle analytics community.

Please set the same parameters at the time of scheduling also:

p_date_from: {$SYSDATE() - 7$}

p_date_to: {$SYSDATE()$}

Thanks.