COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: LEO on 22 Jan 2013 04:31:51 AM

Title: Fact build fails at Data Stream Derivation calculation.
Post by: LEO on 22 Jan 2013 04:31:51 AM
I have a fact build which successfully executes at source node. When it proceeds to process the data stream derivations, there are expressions which gets failed.

Examples: I have derivations defined at the datastream.

1. tointeger(SubStr((TOCHAR ( >>>TODATE ( TIME1, 'YYYY-MM-DD HH:MI:SS' ), 'YYYYMMDDHHMISS' )), 1, 8))

"TIME1" is a calculated column in SOURCE node.


2. IFNULL( >>>TRIM( WSE ), '' ) <> ''

"WSE" is direct column from SOURCE node.

3. IF DOCUMENT_ITEM_CHARGE_CD = 1 THEN

this is one of the IF..ELSEIF branch which is also failing.
Title: Re: Fact build fails at Data Stream Derivation calculation.
Post by: MFGF on 25 Jan 2013 08:33:12 AM
Hi,

What type of value is TIME1? It looks like the error is with your ToDate function - if Time1 is already a date, this will cause an error.

Your second expression doesn't make sense. It should finish with the closing parenthesis. Why do you have <> '' after this?

You need to show all of the third expression for us to be able to figure out what may be wrong with it.

Regards,

MF.