COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: sappleg on 29 Jan 2009 01:36:41 PM

Title: Decision Stream Condition Node
Post by: sappleg on 29 Jan 2009 01:36:41 PM
Hi Guys,

I am new to Cognos and trying to insert a condition node to my ETL build. Could someone please confirm if following is the correct syntax to run and compare the sql results:


$U_DAY_SID := LOOKUP('TARGET','SELECT MIN(DAY_SID)+1 FROM DIM_DAYZ WHERE PER_OFF=0');

$U_SYS_DATE := LOOKUP('TARGET','SELECT TO_CHAR(SYSDATE,'YYYYMMDD') FROM DUAL');

IF $U_DAY_SID = $U_SYSDATE THEN RETURN TRUE
ELSE
  BEGIN
    LOGMSG('Dates don't match')
    RETURN FALSE;
  END
Title: Re: Decision Stream Condition Node
Post by: UseCog on 03 Feb 2009 11:07:11 AM
Looks correct,other than a missing semicolon at the end of logmsg statement. You can test this by 'Test' command at the condition node.