Running BIP Reports in BIEE with prompts

I have been working on a lot of BIP/BIEE integrations lately. One thing that has come up which the Oracle by Example for BIEE/BIP training does not cover is the case where I want my BIP report to be driven by parameters from within a BIEE dashboard page.

Something like this:

BIEEPrompt2.jpg

Its a simple report requiring just a single parameter but how do I get a BIEE prompt to be passed through to the BIP server?
It's pretty simple really, first off you need to create the BIP report with the parameters defined, no need for LOVs, unless you want to run the report from the BIP interface too. Once you have the report defined it's then a case of setting up the dashboard page prompts.

BIEEPrompt.jpg

The trick is to create a presentation variable associated with the prompt that exactly matches the BIP report parameter name, in this example its p_student_id.

You can create as many prompts as you have BIP parameters and of course you can create cascading values for the dashboard prompt list of values.
Now when the report renders you will have dashboard prompts for your users to select from and then hit Go to refresh the report data.

Comments:

Is there any way to pass multiple values from a dashboard prompt, As dashboard prompt with multi select control does not support presentation variable. In that case how would i pass user selected values to BIP Report? Thanks

Posted by Madan on January 28, 2009 at 01:35 PM MST #

Presentation variables are single value, though. What if we want the user to be able to use a multi-select? Or even a between?

Posted by Kurt Wolff on March 20, 2009 at 06:34 AM MDT #

Hello, How would you pass a list of values from an OBIEE prompt to a BI publisher report, as indicated in the previous posting presentation variables are single-valued. Thanks Fiston

Posted by Fiston on March 11, 2010 at 01:07 AM MST #

Hi
how do i configure the dashboard of obiee to BI publisher of 11g.
both are in same version. how to call the sql query and also needed prompts has values like 90 days, 30 days, 7 days etc.

how can i achieve.
Reards
jagadesan

Posted by guest on November 21, 2011 at 01:52 PM MST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today