Report service and batch report service advanced settings

This section describes advanced settings for the report service and batch report service.

BDS.split.maxKeysPerChunk

Specifies the maximum key limit for burst reports processing. Setting the key limit lets you avoid complex SQL clauses when the RSVP.BURST_DISTRIBUTION setting is set to true. The value of 0 sets no limit on this parameter.

Data type:
Positive integer
Default:
1000

EnableChartTransparencyIE

Specifies whether charts use Internet Explorer display filters to enable transparency.

Data type:
Boolean
Default:
true

HyperlinkButtonNewWindow

Specifies that when a hyperlink button is clicked, a new window is created.

Data type:
Boolean
Default:
false

HyperlinkMultipleToolbars

Specifies that duplicate toolbars in HTML reports are permitted. Set to false to eliminate duplicate toolbars from appearing.

Data type:
Boolean
Default:
true

RSVP.ATTACHMENTENCODING.BASE64EXTENDED

Specifies whether base64 encoding is used when generating report output in MHT or XWLA format.

In some instances, if custom applications specify MHT or XLWA output format for reports, problems with end of line characters used in the XML output can prevent applications from opening the report.

Data type:
Boolean
Default:
false

RSVP.BURST_DISTRIBUTION

Specifies that burst reports run in parallel. If you set this option to false, jobs run sequentially, which takes more time.

Data type:
Boolean
Default:
true

RSVP.BURST_QUERY_PREFETCH

When you set this option to true, 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. This setting is applicable to dynamic query mode relational models only.

Data type:
Boolean
Default:
false

RSVP.CHARTS.ALTERNATECOLOURS

Specifies that each chart instance assigns colors in palette order, and does not attempt to preserve the color of items from one chart instance to another.

Data type:
Boolean
Default:
false

RSVP.CONCURRENTQUERY.ENABLEDFORINTERACTIVEOUTPUT

Enables concurrent query execution when the report service is producing interactive output.

Data type:
Boolean
Default:
false

RSVP.CONCURRENTQUERY.MAXNUMHELPERSPERREPORT

Specifies the maximum number of query execution helpers for each report. This parameter is used to prevent a single report from consuming all available query execution helpers.

Data type:
Integer
Default:
1

RSVP.CONCURRENTQUERY.NUMHELPERSPERPROCESS

Enables concurrent query execution and set the maximum number of query execution helpers for each report service or batch report service process. The default value is 0, meaning that concurrent query execution is disabled.

Data type:
Integer
Default:
0

RSVP.CSV.DELIMITER

Specifies the field delimiter character used for CSV output.

Data type:
String
Default:
TAB

RSVP.CSV.ENCODING

Specifies the encoding that is used when generating CSV output.

Data type:
String
Default:
utf-16le

RSVP.GROUP_METADATA_REQUESTS

Specifies if metadata requests are grouped, when possible, to improve performance. Users can disable the grouping of metadata requests by setting this parameter to false.

Data type:
Boolean
Default:
true

RSVP.CSV.MIMETYPE

Specifies the MIME type that is attributed to the CSV output.

Data type:
String
Default:
application/vnd.ms-excel/

RSVP.CSV.QUALIFIER

Specifies the string qualifier that is used for CSV output.

Data type:
String
Default:
"

RSVP.CSV.REPEAT_XTAB_LABELS

Specifies whether to repeat the edge labels in a nested crosstab report.

Data type:
Boolean
Default:
false

RSVP.CSV.TERMINATOR

Specifies the line terminator that is used for CSV output.

Data type:
String
Default:
LF

RSVP.DRILL.clearAllMappedParamsOnMismatch

Specifies how mapping of passed parameter values is processed during a drill-through operation when some parameters fail to map. The parameter mapping is continued (default), or all the mapping is discarded and the user is prompted for values.

When you set this property to 1, if any parameter fails to map, all other mapped parameters are removed from the mapping table. This could cause re-prompting for all missing parameters. When you set this property to 0, if any parameter fails to map while the drill-through component attempts to map the parameters, the mapping of the remaining parameters is not affected.

Data type:
Integer
Default:
0

RSVP.CSV.TRIMSPACES

Specifies that trailing spaces are removed from CSV output.

Data type:
Boolean
Default:
false

RSVP.DRILL.DynamicFilterUsesBusinessKey

Specifies dynamic drill-through filter behavior. Set this option to 1 if you want drill-through to generate a filter using the Member Business Key instead of the default Member Caption.

Data type:
Positive integer
Default:
0

RSVP.DRILL.ExtractSourceContextFromRequest

Specifies whether the report server makes an attempt to extract the metadata for the parameters of the drill-through request from the source context of the request instead of issuing a new metadata request. This type of processing improves performance of a drill-through operation. It is turned on by default.

When you set this property to 0, metadata requests are always issued.

Data type:
Integer
Default:
1

RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET

Enables support for large Microsoft Excel 2007 worksheets. When this option is set to true, worksheets with up to 1,048,576 rows are supported.

Data type:
Boolean
Default:
false

RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE

Adjusts the internal memory fragment size, in rows, that the IBM Cognos Business Intelligence server generates before flushing to a disk. This property can be useful when there are issues, such as running out of memory, when generating reports with the default value. The values might need to be lowered to allow the report to run successfully.

Data type:
Integer
Default:
45000 (approximate)

RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS

Specifies the number of rows to output before moving to a new worksheet.

Data type:
Integer

RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE

Specifies that, when producing output in Microsoft Excel 2007 format and page breaks are specified, the worksheet tabs are named for the data items used to break the pages.

Data type:
Boolean
Default:
false

RSVP.EXCEL.XLS2007_PRINT_MEDIA

Specifies whether the Don't Print style is applied to Excel 2007 report outputs.

Data type:
Boolean

RSVP.FILE.EXTENSION.XLS

Specifies to use XLS as the file extension on XLS output format email attachments instead of HTML.

Data type:
String
Default:
false

RSVP.PARAMSCACHEDISABLED

Specifies whether parameters caching is disabled or enabled at the server level. By default, parameters caching is disabled.

To enable parameters caching for the server, set the RSVP.PARAMSCACHEDISABLED to false. Once enabled, the setting takes effect when reports are updated and saved and the parameter and prompt metadata is embedded in the report specification.

Users can edit a report specification to override the server setting for parameters caching.

If the value for the advanced property RSVP.PARAMSCACHEDISABLED is true at the server level, to enable parameters caching for a report, in the <XMLAttributes> of a report specification, add the following attribute:

<XMLAttribute name="paramsCacheDisabled" value="false"/>

If the value for the advanced property RSVP.PARAMSCACHEDISABLED is false at the server level, to disable parameters caching for a report, in the <XMLAttributes> of a report specification, add the following attribute:

<XMLAttribute name="paramsCacheDisabled" value="true"/>
Data type:
Boolean
Default:
true

RSVP.PARAMETERS.LOG

Specifies whether the report run options and prompt parameters must be logged to the logging system.

Data type:
Boolean
Default:
false

RSVP.PARAMETERS.SAVE

Specifies that report prompt values that are entered by a user are saved automatically.

Data type:
Boolean
Default:
false

RSVP.PRINT.POSTSCRIPT

Specifies which interface to use to print PDF documents from a UNIX operating system. When this option is set to false, the Adobe Acrobat PDF interface is used. Otherwise, the internal postscript interface is used.

Data type:
Boolean
Default:
true

RSVP.PROMPT.CASTNUMERICSEARCHKEYTOSTRING

Specifies to convert numeric data items into a string (varchar) format. This may be required if your data source does not convert numeric data items to strings.

Data type:
Boolean
Default:
false

RSVP.PROMPT.EFFECTIVEPROMPTINFO.IGNORE

Disables the issuing of the effectivePromptInfo attribute in metadata requests and effectively disables moving the prompt information from under the caption attribute of a level to the level itself. This is the default behavior.

Data type:
Boolean
Default:
false

RSVP.PROMPT.RECONCILIATION

Specifies a system-wide configuration that defines how queries and query groups are processed.

See the topic on setting query prioritization in the IBM Cognos Business Intelligence Administration and Security Guide for a description of the possible values of this setting.

Data type:
Positiver integer or string
Default:
0 or COMPLETE

RSVP.PROMPT.RECONCILIATION.CHUNKSIZE

Specifies the chunk size when the value of the RSVP.PROMPT.RECONCILIATION setting is CHUNKED GROUPED or CHUNKED.

Data type:
Positive integer
Default:
5

RSVP.PROMPTCACHE.LOCALE

Specifies the locale to use instead of the locale specified in the report whenever prompt cache data is created, updated, or used. This means that a single prompt cache is used for each report regardless of the report user's locale.

Data type:
String

RSVP.RENDER.PDF_FONT_SWITCHING

Specifies that each character in a string is displayed in the preferred font. The preferred font is any font listed in a report specification, followed by the fonts listed in the global styles cascading stylesheet (css) file. When a character is not available in the preferred font, it is displayed using the next font on the list.

In previous versions of IBM Cognos BI, a font was used only if all characters in a string could be displayed using that font. Starting with IBM Cognos BI 10.1, the preferred font is applied at the character level. As a result, one word can be displayed using different fonts, or some fonts might be bigger, which can cause word wrapping.

Set the parameter value to false to restore the font-choosing behavior of earlier versions of IBM Cognos BI.

Data type:
Boolean
Default:
true

RSVP.RENDER.ROUNDING

Specifies the rounding rule for data formatting.

In previous versions of IBM Cognos Business Intelligence (BI), the halfEven rule was used when rounding numbers. This rule is often used in bookkeeping. However, precision regulations in some regions require different rounding rules, for example, the halfUp rule. Starting with IBM Cognos BI version 10.2.0, you can choose a rounding rule that complies with the precision regulations in your organization.

The following rounding rules are available:

halfEven
Rounds to the nearest neighbor, where an equidistant value is rounded to the nearest even neighbor.
halfDown
Rounds to the nearest neighbor, where an equidistant value is rounded down.
halfUp
Rounds to the nearest neighbor, where an equidistant value is rounded up.
ceiling
Rounds to a more positive number.
floor
Rounds to a more negative number.
down
Rounds towards zero.
up
Rounds away from zero.
Data type:
String
Default:
halfEven

RSVP.RENDER.VALIDATEURL

Specifies whether IBM Cognos Application Firewall validation is imposed on URLs that are contained within a report specification (including URLs on image tags, buttons, hyperlinks, and background images in CSS rules) or are specified by the cssURL run option of the report.

When this option is set to true and CAF in enabled, validation occurs using the following rules:

  • Fully qualified, or absolute URLs:

    protocol://host[:port]/path[?query]

    Where protocol is either 'http' or 'https' and the host is validated against the valid domain list

  • URLs relative to the server installation web root:

    /<install root>/.*

    Where <install root> is the gateway file path, taken from the Gateway URI in IBM Cognos Configuration. For example, /ibmcognos/ps/portal/images/action_delete.gif

  • One of the following specifically allowed URLs:
    • about:blank (case insensitive)
    • JavaScript:window.close() (case insensitive, with or without trailing semi-colon)
    • JavaScript:parent.close() (case insensitive, with or without trailing semi-colon)
    • JavaScript:history.back() (case insensitive, with or without trailing semi-colon)
    • parent.cancelErrorPage() (case insensitive, with or without trailing semi-colon)
    • doCancel() (case insensitive, with or without trailing semi-colon)
Data type:
Boolean
Default:
false

RSVP.RENDER.VALIDATEURL.XLS

Specifies whether rules are applied to values specified by any URL values that are contained within a report specification. CAF must be enabled for this setting to take effect.

Data type:
String
Default:
false

RSVP.REPORTSPEC.LOG

Specifies whether report specifications must be logged to the logging system.

Data type:
Boolean
Default:
false