Oracle Transactional Business Intelligence

Products Banner

How to Pass Parameter from Dashboard to BI Report

680
Views
21
Comments

Summary

Passing Parameter from Dashboard to BI Report

Content

Hi Experts,

I have a BI Report which has a parameter. (A List of Value Item which gets value from a SQL Query)

The standalone BI Report works fine.

The BI Report is embedded in a Dashboard.

Now I would like to know how can we ensure that the said BI Report works fine in the Dashboard too.

Any worked out example (containing a very simple Report and with screen-shots ) would be wonderful

Thanks in Advance!

Kind Regards

Ashish

Comments

  • Hi Ashish,

    One of the report I developed using Logical SQL, I passed values through Presentation Variable and that way I am able to sync up the analysis and prompt. I have attached the screenshots for your reference. See if this is something that can help you.

    Thanks

    Jagadish

    Capture 3.PNG

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Thanks Jagadish for the response, but you have used a OTBI Analysis instead of a BI Report. Do you have something similar which utilizes BI Report

    Kind Regards

    Ashish

  • rajArun
    rajArun ✭✭✭✭

    Hi Ashish,

     

    Try the below steps:

    Create a dashboard prompt with the same name as the prompt / parameter that you have created in the Data Model.

    Add the dashboard prompt and the BI report to the Dashboard.

     

    Thanks,

    Arun

  • Hi Ashish, 
    The prompt is working for the "text" type dashboard prompt with same name as the name of the variable in the report.

    But i require a LOV(choice List) dashboard prompt
    And i want the values in the choice list from the SQL command ( select person_number from PER_PERSON_SECURED_LIST_V).
    This dashboard prompt is giving an error.(---------------Failed to load(Odbc driver returned an error (SQLExecDirectW))--------------)

    Regards
    Pranav

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Hmmm.

    Have you raised an SR yet.

    Do you want to have the Report embedded within Dashboard Only.

    You might even explore submission via ESS Jobs (It allows using PVO which stands for Parameter View Objects which allows selection from drop down list.. just check whether a PVO for Person_number exists.. one cant create Custom PVOs on Cloud Deployment Model)

    Alternatively you may even explore submission using Payroll Flow patterns too

    Note: Request other experts to please share their insights too

    Kind Regards

    Ashish

     

     

  • rajArun
    rajArun ✭✭✭✭

    Ashish,

    Correct me If am wrong. 

    If there is a standard PVO for person_number then Pranav may be able to use it for LOV in a custom ESS Job. As far as I know table validated Value Sets cannot be attached to a parameter as a LOV at this point; meaning you cannot create a custom value set (table validated) and then use it. 

    The below notes should give more clarification for Pranav on attaching Value sets to parameters of a Custom ESS job: 

    Register LOV's Using Seeded Application VOs As Parameters to a Custom ESS Job (Doc ID 1982006.1)

    ​How to Create Dependent LOV Parameters for Custom ESS Jobs? (Doc ID 2173057.1)

     

    Thanks,

    Arun

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Yes to all the points mentioned with one addition info:

    We also have an option of submitting BIP Reports via Payroll Flow Patterns and there is an option of :

    1. Using a Value Set Display Format under Flow Parameters (it currently is allows association with Lookup Code, but I believe there could be ray of hope there. Not Sure how does having Value Set Display helps if you cant actually attach a Value Set there

    2. One is allowed to use a Custom SQL there ( SQL Bind option)

    3. Also I guess Flow Task Parameters too allows usage of a Custom SQL

    So net-net while attaching a value Set directly is not supported but using Custom SQL still is available as an option ( A robust POC needs to be performed before we at conclude)

    I request Product Development Managers and other experts to please help/advise here.

    Kind Regards

    Ashish

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Yes to all the points mentioned with one addition info:

    We also have an option of submitting BIP Reports via Payroll Flow Patterns and there is an option of :

    1. Using a Value Set Display Format under Flow Parameters (it currently is allows association with Lookup Code, but I believe there could be ray of hope there. Not Sure how does having Value Set Display helps if you cant actually attach a Value Set there

    2. One is allowed to use a Custom SQL there ( SQL Bind option)

    3. Also I guess Flow Task Parameters too allows usage of a Custom SQL

    So net-net while attaching a value Set directly is not supported but using Custom SQL still is available as an option ( A robust POC needs to be performed before we at conclude)

    I request Product Development Managers and other experts to please help/advise here.

    Kind Regards

    Ashish

  • rajArun
    rajArun ✭✭✭✭

    Thanks for the info on Payroll Flow Patterns. I am reading about it. My experience is mostly on Financials :)

    I agree with you that we need more details from the experts.

    Regards,

    Arun

  • Hi Ashish,

    Log a SR# with Oracle. They have a code in place to display prompts for BIP in Dashboard. We have successfully been able to do for our client.

    ~Cheers

    Vikram

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Thanks Vikram for your inputs.

    Unfortunately SR isn't a available option (Self-learning purpose)

    Wondering if you have a worked out (step-by-step guide with screenshots embedded) which you would like to share ( please hide customer centric details in case you choose to share one).

    Thanks in Advance!

    Kind Regards

    Ashish

  • Hi Ashish,

    After the code deployment the prompts were available automatically. There were no config or any type of changes done from our side.

    Regards,

    Vikram

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    But there must be a setup done to link Dashboard Prompt with BI Parameter.

    Do you have then snapshot ?

    Kind Regards

    Ashish

  • You don't need to create any dashboard prompt. If your BIP report has a prompt then it will appear automatically. It behaves similarly to OTBI inline prompt

    BIP Prompt on Dashboard.gif

  • AshishERPCloud
    AshishERPCloud ✭✭✭✭

    Ok would re-check.

    Thanks

    Ashish

  • Hi Ashish,

    I am also trying to do same thing am getting odbc error. Did you find anything on how to pass LOV Dashboard Prompt to BIP Report.

    Thanks,

    Karthik

  • HI Arun,

    Thanks for your input  i was also facing this same problem when i followed naming convention i could create two prompts of Text and LOV and pass it to my BIP Report.

    Thanks,

    Karthik

  • Hi All, 

    I have a similar requirement. 

    I have a custom BI Report which has a start and end date as input parameter in the report. 

    I tried adding the report directly on to a custom dashboard and then adding this custom dashboard to the seeded "Manager Resources Dashboard" but the prompts are not visible. 

    Next, I created dashboard prompts with start date and end date and used it on my dashboard. But I believe I am missing the step of linking the dashboard prompts to the prompts used in the BI Report. 

    I saw this article -  Dashboard Prompts Not Filtering BIP Report Created Using Oracle BI EE Data Source (Doc ID 2242277.1)

    But this doesn't help either.

    My prompts are date prompts. 

    I was able to find a Video on youtube where he used a custom "OTBI" report and the columns were filtered to be prompted. And the prompts were mapped to the dashboard prompts. How to do the same for a BI Report is the question. 

    Any advise would be helpful. 

    Thanks,

    Vinay

  • This should be the answer to it

    BI Publisher Report Parameter Not Appearing On Dashboard (Doc ID 2102134.1)

  • Hi All ,

    Has anybody found the cause of  'Failed To load (odbc driver returned and error (SQLExecDriectW).)) error which is coming with Dashboard prompt.

  • Followed same steps, still getting the 'Failed To load (odbc driver returned and error (SQLExecDriectW).))' error.