My Oracle Support Banner

Fusion Applications: Prompt / Filter Does Not Work From Analysis, When Using Reports And Analytics BI Composer Tool (Doc ID 1556204.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Sales - Version and later
Oracle Fusion Goal Management Cloud Service - Version to [Release 1.0]
Oracle Fusion Application Toolkit - Version and later
Information in this document applies to any platform.


Qn1:Fusion Applications CRM Cloud
How do I add a prompt to an OBIEE analysis ?

Qn2:Fusion Applications 11.1.6..0.0 CRM - Would like BI Prompts belonging to analyses which have been created in OBIEE Answers, to be usable , when the analysis is executed via BI Composer

Here is the description of the behavior of the Column Prompt of an Analysis in OBIEE Answers :

A column Prompt is a prompt defined on an analysis via the Prompts Tab like below :

When we execute the analysis we first see the prompt :

Then we select some values and click on the OK button we obtain the result of the analysis filtered by the selected value(s) of the prompt :

That’s the normal behavior when using Answers or Dashboards.


Now if we use BI Composer, with that same prompted analysis as above, here is the behavior .

We navigate in the Catalog panel to find the right analysis.
If we choose to View the analysis, then the analysis is executed, but the prompt is not displayed and the result displayed in the right panel is not filtered.
Now if instead of choosing the View command we choose the Edit command, we’ve got the following error message :

WarningL Analysis is incompatible. Do you wish to open ?
Unhandled View: filtersView!1
Unhandles prompts

If we click on Yes, we can edit the analysis and we effectively see that the Prompt object does not have any configuration steps in the wizard.

work-around (which has some difficulties):

Create a dashboard with only one page and the analysis in a section of that page.
When we try to view the dashboard from the BI Composer, then the column prompt is displayed first before the results :
And the analysis is filtered

Issues with the work-around:
The analysis will need to be stored in a folder that must not be accessible via the Contents panel of BI Composer , we must only expose the Dashboard object.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.