Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
report dates parameters not incremented
Angela Valcelli
Rank 2 - Community Beginner
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:
0
Best Answer
-
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.
1
Answers
-
Thanks MandeepGupta
to confirm the solution!
1