TI IsNull Function

Post Reply
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

TI IsNull Function

Post by Eric »

Anyone know the syntax for the TI IsNull function?
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TI IsNull Function

Post 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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TI IsNull Function

Post 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.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TI IsNull Function

Post by Eric »

Sent a ticket in. We will see.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
John Hobson
Site Admin
Posts: 330
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: Any
Version: 1.0
Excel Version: 2020
Location: Lytham UK
Contact:

Re: TI IsNull Function

Post by John Hobson »

Eric

In my help file 9.1. Sp3 it gets one mention as a "reserved word" but nothing else.

J
John Hobson
The Planning Factory
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TI IsNull Function

Post 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
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Renaud MARTIAL
Posts: 25
Joined: Thu May 15, 2008 10:18 am
Location: Paris, France

Re: TI IsNull Function

Post 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.
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TI IsNull Function

Post 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.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Post Reply