OBIEE11g /12: The Dashboard Prompt may not Work to Filter BI Publisher Report made by Subject Area, when the Prompt Value is Numeric
Last updated on MAY 14, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 11g to 12c]
Information in this document applies to any platform.
When you use prompts to filter the results of embedded parameterized BI Publisher(BIP) reports on a BIEE dashboard page, the report is not filtered.
The issue reproduces when the prompt is numerical type; when the prompt is string, the report can be filtered as expected.
In the following screen shot, there are dashboard prompt and a BI Publisher report on a dashboard. Try to filter using the prompt: Product Number = 4.
When the prompt is string type, the report can be filtered. Ex) Product = "MPEG4 Camcorder"
This issue occurs when all of the following conditions are met:
- Use BI Publisher report that uses a subject area as a data source.
- Add parameter for BI Publisher report.
- Use a dashboard and dashboard prompt to filter.
- Use numeric for the prompt.
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