Synchronizing Columns with Your Data Source .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 37
Synchronizing Columns with Text Data Files or IQDs .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 38
Connecting to an IQD Data Source
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 39
Isolation Levels for an IQD Data Source .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 39
Example - Using an .iqd File to Access a UNIX Data Source .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 40
Modify the SQL Query in an IQD Data Source
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 40
Character Sets Used with Delimited Text Data Sources .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 41
Named Ranges .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 41
Example - Specifying Named Ranges for a Multipage Crosstab .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 41
Example - Specifying a Named Range for a Spreadsheet Database .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 42
PowerHouse Data Source Parameters .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 43
Using Multiple Data Sources in Your Model
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 43
Data Source Scope .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 44
Control When the Source Data Is Read .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 46
Defining Columns .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 47
Troubleshooting Issues Related to Column Names
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 48
Troubleshooting Issues Related to Date Columns .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 48
Define Columns in a Fixed-field Text Data Source
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 49
Scale Input Values .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 50
Set the Level of Detail for Dates
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 51
Specify Monthly or Quarterly Time Arrays .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 51
Modify Date Categories When Spanning Two Centuries
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 54
Signons.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 54
Creating a Data Source Signon .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 55
Creating an IBM Cognos Signon
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 56
Chapter 4. Structuring Your Data Into Dimensions . . . . . . . . . . . . . . . . . 57
AutoDesign .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 57
Creating a New Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 58
Creating Dimensions in the Dimension Map Using Relational Data Sources .
.
.
.
.
.
.
.
.
.
.
.
. 58
Creating Dimensions from the Dimension Map Using OLAP and DMR Packages .
.
.
.
.
.
.
.
.
.
. 58
Define a Calculated Column .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 59
Example - Using a Calculated Column to Add an Exception Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
. 60
Example - Using a Calculated Column to Support Allocated Measures
.
.
.
.
.
.
.
.
.
.
.
.
.
. 60
Adding Levels and Categories to a Dimension.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 61
Add Source Levels to a Dimension
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 61
Add Manual Levels to a Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 62
Create Categories Manually .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 63
Creating Calculated Categories .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 63
Order Categories Within Levels.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 66
Order Categories Using a Global Preference Setting .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 67
Create Unbalanced Level Hierarchies Within a Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 67
Drill-down Paths
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 68
Create an Alternate Drill-down Path .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 68
Define a Scenario Dimension and a Cube Opening Level .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 69
Setting Up the Time Dimension.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 70
Creating the Time Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 71
Format Date Values.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 73
Set up Fiscal Years, Quarters, and Months .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 74
Set up Calendar and Fiscal Years Within a Single Time Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 74
Specify How Weeks Split When Spanning a Higher-level Time Period .
.
.
.
.
.
.
.
.
.
.
.
.
.
. 75
Set up Lunar Time Periods .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 76
Specify How Extra Weeks Get Added to Lunar Years
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 77
Limit the Range of Dates Included in the Model .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 77
Set up a Custom Time Dimension .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 78
Setting Up Relative Time Categories .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 79
Set the Current Period Automatically .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 80
Set the Current Period Manually .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 81
Track Changes in a Measure over a Specific Time Period .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 81
Track Changes in a Measure for a Period-to-Date .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 82
Track Changes in a Measure over Several Time Periods.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. 83
iv
IBM Cognos Transformer Version 10.1.1: User Guide
Summary of Contents for Cognos
Page 1: ...IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 106: ...92 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 136: ...122 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 160: ...146 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 174: ...160 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 326: ...312 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 352: ...338 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 394: ...380 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 398: ...384 IBM Cognos Transformer Version 10 1 1 User Guide ...
Page 411: ...Y year function 362 years between function 362 Index 397 ...