Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

All Column Values in BI Publisher

Received Response
355
Views
15
Comments
Deepthi Suravaram
Deepthi Suravaram Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Summary

All Column Values in BI Publisher

Content

Hi All,

I am OBIEE 11.1.1.9. I am trying to embed a BI Publisher report on APCC Dashboard. I am trying to use OBIEE Prompt to pass the values to BI Publisher report. It works fine if I am passing single value or multiple values, but it doesn't work for 'All Column Values' selection.

The report is erroring out for 'All Column Values'

Is there any way this can be done?

Regards,

Deep

«1

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach 
    911309 wrote:Hi Sherry,Thanks for the reply. The data model is a sql query. I have the following error

    image

    ok, when you select "All column values" in OBIEE, it looks like a value like *)nqgtac(* is passed to the BI publisher variable. So in your case (I do not know what your  WHERE clause is)

    a WHERE condition like :variable_name='*)nqgtac(*' could be added to handle the "All column values" scenario.

    Note: this probably is not a supported approach.

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    Hi Jasmine,

    Thanks for the reply. I am able to pass multiple values to the report and it works fine. The problem comes only with 'All Column Values'. The doc ID suggests addition of below tag

    <AdvancedReporting>

    <ReportingToolbarMode>6</ReportingToolbarMode>

    </AdvancedReporting>

    But that is for displaying the parameters from BI Publisher. I am using OBIEE Prompts and publisher parameters.

  • Jasmine Pauline
    Jasmine Pauline Rank 5 - Community Champion

    Business Intelligence Publisher 11.1.1.7 Report Fails From BI Analytics Dashboard With Error 'oracle.xdo.XDOException: oracle.xdo.servlet.data.DataException: Invalid parameters requested.[[at oracle.xdo.online.DataCache.getDataFile' (Doc ID 2231399.1) seems similar to your issue.

    HTH-

    Jasmine

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    Hi Sherry,

    Thanks for the reply. The data model is a sql query. I have the following error

    image

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Please post the error.What is the data model of the BI publisher report, is it a SQL query?

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    I think I spoke to soon. It's erroring out with the same error.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Did the updated filter work ? if not did you get the same error? Also I don't see a varchar type in BI publisher parameter data type. Post the complete SQL

    Also I'm guessing you have created the same presentation variable(P_MODEL) in OBIEE prompt.

    Edit: Saw your update, glad it worked. Please close the thread by marking as Answered.

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    Hi Sherry,

    The following where clause worked for me.

    (:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*')

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    It's varchar

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Try something like below

    where (model

    IN (:P_MODEL) OR :P_MODEL='*)nqgtac(*')

    What is your parameter data type?