Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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?
Summary
Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent
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"
Tagged:
8