X

An Oracle blog about BI Publisher

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.

Join the discussion

Comments ( 4 )
  • Madan Wednesday, January 28, 2009
    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
  • Kurt Wolff Friday, March 20, 2009
    Presentation variables are single value, though. What if we want the user to be able to use a multi-select? Or even a between?
  • Fiston Thursday, March 11, 2010
    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
  • guest Monday, November 21, 2011

    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


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.