Dynamic Date Parameters in BI Report
Dynamic Date Parameters in BI Report

 1,778 total views

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. 

Want to learn Fusion Technical tools go through this post

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

dynamic date parameters, last day of the month, first day of the month, first day of year, last day of year in fusion hcm bi reports

We can use these values in the BI Data Model as the default values and when the report is scheduled, the dates will be picked up dynamically based on the sysdate.

dynamic date parameters, last day of the month, first day of the month, first day of year in fusion hcm bi reports oracle hcm cloud parameter defaults

Summary:
Using the above expressions you can populate the default date values when you run the BI Publisher report.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 5 Comments

  1. Gopi

    Hi Bro,

    Is there anyway to get first day and last day of previous month dynamically?

    Thanks,
    Gopi

  2. Sricharan

    Hi Gopi,

    There isn’t a way to get the First day and Last day of the previous month dynamically. It has to be handled in the SQL Query only if there is such need.

    Thanks,
    Sricharan

  3. Colin

    Hi Sir,

    Is is possible to attach a query on Date Parameter’s default value to achieve the retrieval of 1st and last day of the previous month?
    Or not? I’m seeing that BIP Date Parameter – Default Value is only limited to the set of this functions / expression you have given above.

    Thanks,
    Colin

  4. Sricharan

    Hi Colin,
    It isn’t possible to default the 1st day of previous month for the date parameters. We can get the last day of previous month by using {$FIRST_DAT_OF_MONTH()-1$}. You can write this logic in the SQL query in the data model itself.. We have limited scope to define the defaults for the date parameters.We can’t go beyond that..
    Thanks,
    Sricharan

Leave a Reply