Page 1 of 1
TI IsNull Function
Posted: Thu May 22, 2008 2:17 pm
by Eric
Anyone know the syntax for the TI IsNull function?
Re: TI IsNull Function
Posted: Fri May 23, 2008 7:52 am
by Martin Ryan
Didn't know there was one, though if there is, the syntax should be in the help files - though I find the Cognos ones aren't quite as easy to search with as the old ones. (Again no TM1 on this computer, so can't tell you specifically).
Failing that, what are you trying to achieve?
Martin
Re: TI IsNull Function
Posted: Fri May 23, 2008 1:53 pm
by Eric
Wish it was that easy. It is mentioned in the Guide, but not in the help and there is no syntax. I looked for over an hour! How frustrating.
Re: TI IsNull Function
Posted: Fri May 23, 2008 4:19 pm
by Eric
Sent a ticket in. We will see.
Re: TI IsNull Function
Posted: Wed May 28, 2008 6:45 am
by John Hobson
Eric
In my help file 9.1. Sp3 it gets one mention as a "reserved word" but nothing else.
J
Re: TI IsNull Function
Posted: Wed May 28, 2008 1:10 pm
by Eric
Here is the syntax. I have not given it a try yet, but I think it might only be valid in the Data and Metadata tabs,
Code: Select all
if (ISNULL(myvar) = 1)
#its null
else
#its not
endif
Re: TI IsNull Function
Posted: Thu May 29, 2008 2:47 pm
by Renaud MARTIAL
Hello,
this function is perhaps used when you retrieve data from an ODBC data source ?
Its syntax looks like the one used in plain SQL to check null values ...
Regards,
Renaud.
Re: TI IsNull Function
Posted: Thu May 29, 2008 3:16 pm
by Eric
this function is perhaps used when you retrieve data from an ODBC data source ?
Ding! Ding! Ding! You are correct, great Insight (pun.....maybe
). Cognos support just confirmed it is only used in connection with the ODBC in the Data and MetaData Tabs.