Need help on Creating OTBI dashboard for BI Publisher Reports with Date From and Date To Parameter

Kundan Kumar17

Need help on Creating OTBI dashboard for BI Publisher Reports with Date From and Date To as Parameter.

We have a requirement to build dashboard for few of the BI Publisher REPORT with Date From and Date To Parameter.

I am able to create dashboard, but when i am passing parameters, i am not getting any result filtered based on the parameter.

Looking for some help on how can we pass Date From and Date To parameter on Dashboard for BI Publisher Report.

Thanks!!

Mallikarjuna Kuppauru-Oracle

Hi @Kundan Kumar17

You have to create the parameters name in the bipublisher with same as your Presentation variable name's.

Refer below link for more steps -

https://forums.oracle.com/ords/apexds/post/how-to-pass-prompt-values-on-dashboard-to-bi-publisher-repo-0017

http://appselangovan.blogspot.com/2013/05/passing-parameters-from-obiee.html

Regards,

Arjun

Dimple-Nagesh-Support-Oracle

Hello @Kundan Kumar17,

Please follow below steps:

1. Create a variable dashboard prompt using presentation variable.
2. Name of presentation variable should be same as parameter name in BIP report.
3. You can Select "User Input" as List box and select "SQL Results" in "List of values" if required.
4. You can also select "Enable user to select multiple values" if required.
5. Save this DB prompt and drag it into your dashboard.

Now this DB prompt will act as parameter for BIP report.

Hope this helps

Thanks,
Dimple N

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24044/need-help-on-creating-otbi-dashboard-for-bi-publisher-reports-with-date-from-and-date-to-parameter

Below post should be helpful as well:

How to embed BIP report in OTBI dashboard with Date Prompt/parameter? — Cloud Customer Connect

Thanks.

Kundan Kumar17

Thank you everyone for the answers.

However i need to pass two Date parameters and need to use Between operator?

Also can i create dashboard prompt using any subject area having time dimension?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61937#Comment_61937

Are you not able to create two date parameters following the approach on below link?

https://community.oracle.com/customerconnect/discussion/585077/how-to-embed-bip-report-in-otbi-dashboard-with-date-prompt-parameter

Bhaskar Konar

What issues are you getting after following the post that Mandeep has kindly shared @Kundan Kumar17?

Kundan Kumar17

Hi @Bhaskar Konar & @MandeepGupta,

I want BIP parameter datatype to be date not text.

Thanks

Bhaskar Konar

Hi @Kundan Kumar17,

Can you please share some screenshot detailing the issue you are getting or the requirement that you have. It'll help us to understand your specific problem and will enable us to work on any work around / solution etc.

Cheers,

Kundan Kumar17

Hi @Bhaskar Konar ,

I need to pass Date from & Date To on same column(Hire date) from Dashboard prompts to BIP Report as per below screen shot.

Thanks

Bhaskar Konar

Hi @Kundan Kumar17,

Can you please try the following?

• Create a dashboard prompt with a 2 date columns and define a presentation variable for each of them. Like: pvToDate & pvFmDate. You can use any default value if required as it is optional.
• Now use those 2 variables in your Data Model Query. i.e.: trunc(HIRE_DATE) >=:pvToDate AND trunc(HIRE_DATE) <= :pvFmDate

Hope this help.

Cheers,