Create the data sources in Cognos Transformer

This example is based on an IBM® Cognos® package with one query and an IBM Cognos report with one query.


CognosPackageAdd 103 "GO Sales and Retailers" SourceType Package 
SourcePath "/content/package[@name='GOSales and Retailers']" PackageTimeStamp 
"/content/package[@name='GOSalesand Retailers']/model[@name='model']"


CognosPackageAdd 115 "GSR_rpt_1"SourceType Report SourcePath
 "/content/package[@name='GO Sales and Retailers']/report[@name='GSR_rpt_1']"
PackageTimeStamp 
"/content/package[@name='GOSales and Retailers']/report[@name='GSR_rpt_1']"


DataSourceAdd 105 "GO Salesand Retailers~1" Separator "," 
SourceType CognosSourceQuery CharacterSetDefault DecimalSep "." 
Thousandsep "," Columns True Timing PopYesCreateDefaultPackageReportSource
103 "GO Sales and Retailers" AutoSummary TrueSetCurrent True  ServerSource
False Speed False Presummarized False


ColumnAdd 107 "[gosales_goretailers].[Orders].[Ordernumber]"
DataSource 105 Origin Source Offset 0 Column "Order number"Storage
Float64 Scale 0 Size 4 Decimals 0 InputScale 0 TimeArrayOff Rollup
CountAll

ColumnAdd 109 "[gosales_goretailers].[Orders].[Retailername]"
DataSource 105 Origin Source Offset 1 Column "Retailer name"Storage Text 
Scale 0 Size 102 Decimals 0 Class Description InputScale0 TimeArray Off

ColumnAdd 111 "[gosales_goretailers].[Orders].[Orderyear]"
DataSource 105 Origin Source Offset 2 Column "Order year"Storage Float64 
Scale 0 Size 4 Decimals 0 InputScale 0 TimeArrayOff Rollup CountAll

ColumnAdd 113 "[gosales_goretailers].[Orders].[Ordermonth]"
DataSource 105 Origin Source Offset 3 Column "Order month"Storage Float64 
Scale 0 Size 4 Decimals 0 InputScale 0 TimeArrayOff Rollup CountAll


DataSourceAdd 117 "GSR_rpt_1~1" Separator ","  SourceTypeCognosSourceQuery
CharacterSet Default DecimalSep "."  Thousandsep"," Columns True
Timing PopYesCreateDefaultPackageReportSource 115"GSR_rpt_1" AutoSummary
False SetCurrent True ServerSource False Speed False Presummarized
False

ColumnAdd 119 "[Report].[Query1xx.0].[Order number]"DataSource
117 Origin Source Offset 0 Column "Order number" StorageFloat64
Scale 0  Size 1 Decimals 0 Class Quantity InputScale 0 TimeArrayOff


ColumnAdd 121 "[Report].[Query1xx.0].[Order date]" DataSource117 
Origin Source Offset 1 Column "Order date" Storage Int32 Scale0 Size 1
Decimals 0 Class Date InputScale 0 TimeArray Off


ColumnAdd 123 "[Report].[Query1xx.0].[Product name]"DataSource
117 Origin Source Offset 2 Column "Product name" StorageText Scale 0
Size 1 Decimals 0 Class Description InputScale 0 TimeArrayOff


ColumnAdd 125 "[Report].[Query1xx.0].[Quantity]" DataSource117
Origin Source Offset 3 Column "Quantity" Storage Float64 Scale 0 Size 1
Decimals 0 Class Quantity InputScale 0 TimeArray Off

ColumnAdd 127 "[Report].[Query1xx.0].[Revenue]" DataSource117
Origin Source Offset 4 Column "Revenue" Storage Float64 Scale2  Size 1
Decimals 2 Class QuantityInputScale 0 TimeArray Off