Print Page - Euqivalent functions in Cognos 8

Title: Euqivalent functions in Cognos 8
Post by: Mpotla on 07 Jul 2009 10:20:29 AM

Hi All,

we have two cubes created using .imr as iqds, which has the functions like
cdate(T1."FISCAL_CALENDAR_DT"),
cdatetime((cdate((curdate()))) + cinterval(8)))),
@CURRENT_DATE.

I have to redesign the similar cubes with slight changes in the coding using Cognos 8.

Can anybody help me the purpose of those functions ,the equivalent function in Cognos 8 FM.

Thanks in Advance
Mohan

Title: Re: Euqivalent functions in Cognos 8
Post by: maddycdp on 31 Mar 2012 09:41:51 AM

Hi Mohan,

I have exactly same requirement. Do you have any clue for

cdate(T1."FISCAL_CALENDAR_DT"),
cdatetime((cdate((curdate()))) + cinterval())),
@CURRENT_DATE.

Thanks
Maddy

Title: Re: Euqivalent functions in Cognos 8
Post by: blom0344 on 31 Mar 2012 03:56:43 PM

The CDate function converts Numbers, Strings, DateTime, and YYYY, MM, DD values to date values.

The CDateTime function converts Numbers, Strings, Dates, YYYY, MM, DD, and HH, MM, SS values to DateTime values.

Perhaps the cast function would be the first place to look. Would depend on the nature of the data..

Title: Re: Euqivalent functions in Cognos 8
Post by: maddycdp on 01 Apr 2012 10:40:25 AM

Thank you for your response. Do you have any clue for cinterval().

Thanks in Advance
Maddy

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mpotla on 07 Jul 2009 10:20:29 AM