You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not a Question: Dynamic Date Parameters in BI Report

Received Response
80
Views
5
Comments
edited Jul 17, 2019 11:07AM in Reporting and Analytics for HCM 5 comments

Content

This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes we also have a date range "From Date" and "To Date" to fetch transactions between those dates. And these dates need to have a default value when we open the report/schedule the report.

In this article we will try and see what are all the options possible for defaulting date parameters for BI Report.

Expression

Description

Date Format String

{$SYSDATE()$}

Current Date / System Date

MM-dd-yyyy

{$SYSDATE()+1$}

Day next to System date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!