Categories
All Column Values in BI Publisher
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
Answers
-
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.
0 -
Please post the error.What is the data model of the BI publisher report, is it a SQL query?
0 -
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.
0 -
Hi Sherry,
Thanks for the reply. The data model is a sql query. I have the following error
0 -
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
0 -
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.
0 -
Try something like below
where (model
IN (:P_MODEL) OR :P_MODEL='*)nqgtac(*')
What is your parameter data type?
0 -
I think I spoke to soon. It's erroring out with the same error.
0 -
Hi Sherry,
The following where clause worked for me.
(:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*')
0 -
It's varchar
0