Print Page - External Data Functions

Title: External Data Functions
Post by: Bonediggler on 18 Mar 2016 02:43:00 PM

Experts -

What functions are available to be used with External Data? Specifically I need to create a filter like: "DateField between _add_days(date(),-84) and date().

Apparently this doesn't work as date(), although a Cognos function/constant, does not seem available when used against external data.

Thanks in advance!

Title: Re: External Data Functions
Post by: cognos-t on 21 Mar 2016 04:32:11 AM

Hi,

you might try current_date instead.

Regards

Title: Re: External Data Functions
Post by: Bonediggler on 23 Mar 2016 10:49:58 AM

Thanks Cognos-t. Is there any documentation/general information regarding how and what functions can be used against External Data? I haven't found much so far.

Title: Re: External Data Functions
Post by: cognos-t on 24 Mar 2016 04:27:16 AM

Hi Bonediggler,

you can basically use all functions which are not vendor specific. In order to get an overview of common functions, create a new data item in report studio and click help in right upper corner. A menu with different sub menus will open. There you can find different functions that you can use. The functions can also be found in the report studio guide provided by IBM.

Best regards

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 18 Mar 2016 02:43:00 PM