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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to embed BIP report in OTBI dashboard with Date Prompt/parameter?

edited Apr 12, 2021 6:44PM in Reporting and Analytics for HCM 4 comments

Summary

Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameter

Content

Steps: 

1. Create dashboard column prompt with a date column and define a presentation variable with a name.  You can use any default value if required as it is optional.

 Example: OTBI column:  "Time"."Calendar Date"

                 Presentation Variable Name: P_Date

2. Create a BIP data model with following details. 

Parameter Name with Text type: same as presentation variable i.e. P_Date

Dataset with following filter in where condition. 

"and to_char(DATE_COLUMN, 'yyyy-MM-dd') >=:P_Date"

Example: "and to_char(trunc(effective_start_date), 'yyyy-MM-dd') >=:P_Date"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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