My Oracle Support Banner

12.2 Business Intelligence Parameter Option 'Refresh Other Parameters on Change' Does Not Appear When Defining A BI Publisher Report Data Model Based On Subject Area Fields (Doc ID 2243050.1)

Last updated on FEBRUARY 19, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.


Business Intelligence Publisher Enterprise 12c, Enterprise Data Model Editor issues



When developing a 12.2 BI Publisher report with a Subject Area in the data model, the business requirements are for the lov of one parameter to refresh based on the value of another parameter.

However the parameters in the definition page do not show an option for "Refresh Other Parameters on Change" for reports with a seeded Subject Area in the data model.

For example, there is a report with Subject Area has two parameter as below.

After you select the value of the parameter "Product Number", the value of the parameter "Product" is not refreshed to have only one which is match the value of "Product Number", but still has all value as below.

What the expected the value of the parameter "Product" is "MP3 Speakers System".


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

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

In this Document

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