Starting with version 10.2.1, internal processing of burst
reports in Cognos BI is different than in earlier versions of the product.
You can change the product defaults to revert to the type of processing that was
used in earlier versions of the product.
About this task
To change the product defaults for burst reports processing, use the
following advanced settings:
- RSVP.BURST_DISTRIBUTION
-
- This setting corresponds to the Run in
parallel option in the user interface.
Values: true (default) or false
When you change the default value, burst reports run sequentially in
one process, which takes more time.
- RSVP.BURST_QUERY_PREFETCH
-
- This setting corresponds to the Use
query prefetching option in the user interface. This functionality is
applicable to dynamic query mode relational models only.
Values: true or false (default)
When you change the default value, you enable query prefetching. As a
result, the burst report outputs are produced much faster because the queries
run in parallel with the report rendering.
To complete the process, you must also modify the xqe.config.xml file.
- BDS.split.maxKeysPerChunk
-
- This setting corresponds to the Maximum
key limit option in the user interface.
Values: Positive integer. The default is 1000. The value of 0 sets no
limit on this parameter.
Setting the key limit lets you avoid complex SQL clauses when the
RSVP.BURST_DISTRIBUTION setting is set to true.
The settings must be changed globally, for the whole IBM Cognos
environment..
Configuring advanced settings globally
You can configure advanced settings
globally for the whole IBM Cognos environment.
About this task
The values that you specify are acquired by all contained entries.
You can override the global values by specifying custom values at the dispatcher
or dispatcher service level.
If the configuration entry contains child entries with settings that
override the global settings, the custom settings on the child entries can be
reset to use the default values.
You can configure advanced settings globally for the logging, tuning,
environment, and administrator override categories.
Procedure
Click Launch, IBM Cognos
Administration.
1.On the Configuration tab, click Dispatchers and Services.
2.In the toolbar on the Configuration page, click the Set properties – Configuration icon Set properties – configuration.
3.Click the Settings tab.
4.To filter the list of settings, from the Category list, select a category.
5.
Choose the required setting from the list, and specify a value in one of the following ways:
◦Enter a value
◦Select a value from a list
◦Click Edit and add a parameter name and value
6.Optional: To reset the child entries to use the default settings, select the Delete the configuration settings of all child entries check box.
7.Click OK.
8.To apply the values, stop and restart the Cognos services.
