Changing the default processing of burst reports

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.