Enable Subrequest Shipping

Administrators use this system setting to specify if sub-requests to source databases are executed separately as standalone queries or executed together.

By default, sub-requests are shipped separately which can improve performance if you execute complex reports with a large group of sub-requests, that is, you prefer to ship the sub-requests separately in multiple simplified queries rather than ship a large single complicated query all at once.

In Oracle BI Enterprise Edition, the default is set to NO. If you used Oracle BI Enterprise Edition and want to retain the previous default behavior, set this property to NO to continue executing database sub-requests together.

Valid Values

  • Default — Database sub-requests are shipped separately. This is the same as the value YES. Default
  • YES — Database sub-requests are shipped separately.
  • NO — Database sub-requests are shipped together, all at once.

Apply Required

Yes.

Change Effective

After a few minutes.

Edition

Professional and Enterprise.

API Key and Values

API KeyEnableSubrequestShipping

API Values
  • Default
  • YES
  • NO