Fusion Applications: Prompt / Filter Does Not Work From Analysis, When Using Reports And Analytics BI Composer Tool
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Fusion Sales - Version 184.108.40.206.0 and later
Oracle Fusion Goal Management Cloud Service - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Oracle Fusion Application Toolkit - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Qn1:Fusion Applications CRM Cloud 126.96.36.199.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.
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
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.
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