To Next Page

To Previous Page

A Duplicates Rollup setting other than None forces Cognos Transformer to

consolidate the source file when generating cubes, as described in the following

table.

Consolidation

setting Cognos Transformer action

Default or Yes

(with sort)

Sorts the source file, then consolidates duplicate records by using the

Duplicates Rollup function.

No Overrides the Consolidation setting, sorts the source file, and does not

consolidate duplicate records.

The duplicate rollup rule is ignored.

Yes (presort) Consolidates the source data by using the Duplicates Rollup function

without first sorting the source file.

Special Characters

Cognos Transformer and Model Definition Language (MDL) scripts use various

kinds of special character.

Quotation Marks in Data

The MDL syntax reserves single and double quotation marks (’ and ") to delimit

textual data. All text strings are enclosed in either double or single quotation

marks.

When a text string contains both single and double quotation marks, Cognos

Transformer changes the quotation marks to avoid ambiguity. All quotation marks

in the original text are converted to single quotation marks and the entire string is

enclosed in double quotation marks.

For example, in MDL syntax, New York becomes "New York" and Other's

"No-Name" Brands becomes "Other's 'No-name' Brands". Similarly, "London" and

London ' ("prime") becomes "'London' and London ' ('prime')".

We do not recommend using quotation marks to designate imperial measurements,

such as inches or feet. When the quotation marks are switched, your users see

incorrect values. For example, Swivel Castor 2 1/2" Black becomes "Swivel

Castor 2 1/2’ Black".

Search Wildcards

You can use the following wildcard characters in the Find in Category dialog box

when the Use Wildcards check box is selected.

character Search results Example

^ The beginning of a string ^inter finds interesting and interfere,

but not splinters.

$ The end of a string in$ finds in and within, but not

interfere.

? Any single character except newline to? finds top and ton, but not to.

334 IBM Cognos Transformer Version 10.1.1: User Guide

IBM Cognos User Manual

Questions and Answers: