COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: goodknight on 15 Aug 2007 01:17:18 PM

Title: DataManager: Modify data types in fact build?
Post by: goodknight on 15 Aug 2007 01:17:18 PM
Stupid question, but is there a way to modify the data types that DataManager uses when doing a fact build?

It's using a TIMESTAMP data type, but I need it to be DATE.

Thanks!
Title: Re: DataManager: Modify data types in fact build?
Post by: MFGF on 21 Aug 2007 08:38:52 AM
Hi,

Do you mean the datatypes used when Data Manager creates a table for you?  You could try:

a) Editing the properties of your datastream items to define a datatype for each.
b) Having a SQL node (from a jobstream) create the table for you using datatypes and sizes you specify.

Regards,

MF.
Title: Re: DataManager: Modify data types in fact build?
Post by: goodknight on 21 Aug 2007 08:59:53 AM
Good catch!  Thanks again!