nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

All Column Values in BI Publisher

Deepthi Suravaram

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

Find more posts tagged with

Accepted answers

All comments

Sherry George

911309 wrote:Hi Sherry,Thanks for the reply. The data model is a sql query. I have the following error

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

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>

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

Jasmine Pauline

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

Hi Sherry,

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

Sherry George

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

Deepthi Suravaram

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

Sherry George

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

Hi Sherry,

The following where clause worked for me.

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

Deepthi Suravaram

It's varchar

Sherry George

Try something like below

where (model

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

What is your parameter data type?