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 Key — EnableSubrequestShipping
Default
YES
NO