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 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"