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 11.1.6.0.0 and later
Oracle Fusion Goal Management Cloud Service - Version 11.1.7.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Application Toolkit - Version 11.1.6.0.0 and later
Information in this document applies to any platform.

Goal

Qn1:Fusion Applications CRM Cloud 11.1.6.0.0
 
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.

UNEXPECTED BEHAVIOR
--------------------------------

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.
 

Solution

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 hundreds of Community platforms