@ Sign in TI Scripts

Post Reply
FarmboyEsq
Posts: 10
Joined: Thu Jun 07, 2012 9:25 pm
OLAP Product: TM1
Version: 9.52
Excel Version: 14.0.6112.5000

@ Sign in TI Scripts

Post by FarmboyEsq »

Hi,

What is the significance of the @ sign in TurboIntegrator IF / ELSEIF Scripts?

In the "Advanced Scripting" section of the TM1 Turbointegrator manual, it just begins referencing variable G1 as G1@... (Or, is the @ part of the comparison operator, i.e. @= or @<> ?)

Sorry if this is a really stupid question.

Thanks.

Stg
FarmboyEsq
Posts: 10
Joined: Thu Jun 07, 2012 9:25 pm
OLAP Product: TM1
Version: 9.52
Excel Version: 14.0.6112.5000

Re: @ Sign in TI Scripts

Post by FarmboyEsq »

Ah -- found it in the Developer guide under "Expressions".

To compare two string values, insert the @ symbol before the comparison operator, as shown in the following example:

IF ('A'@='B',0,1) yields the number 1.


Thanks.

Stg
tez
Posts: 40
Joined: Tue Dec 21, 2010 12:43 am
OLAP Product: Cognos Express
Version: 10.2.1 FP3
Excel Version: 2013

Re: @ Sign in TI Scripts

Post by tez »

Hi Stg

I'm trying to find some doco on symbols etc that can be/are used in TI scripts, the first one I was looking for was the @ sign, so I'm glad I came across your post :D

I've looked through all the doco under the Help & guides etc on IBM, but can't seem to find the Expressions section in the Developer Guide you had mentioned.

Are you able to tell me which one in particular you found it in? I'm thinking maybe I'm going blind.... :o

Thanks!
Terri
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: @ Sign in TI Scripts

Post by Alan Kirk »

tez wrote:I've looked through all the doco under the Help & guides etc on IBM, but can't seem to find the Expressions section in the Developer Guide you had mentioned.

Are you able to tell me which one in particular you found it in? I'm thinking maybe I'm going blind.... :o
You may want to take a look in the FAQ thread which includes links to frequently referenced sections in the documentation. You'll find it under the heading "Frequently Referenced Sections", in particular the "Rule Syntax" link. (When you get to the page, look under the "Comparison Operators" group. TI's use broadly the same syntax as Rules.)

Or if you want the more direct route, click here.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
tez
Posts: 40
Joined: Tue Dec 21, 2010 12:43 am
OLAP Product: Cognos Express
Version: 10.2.1 FP3
Excel Version: 2013

Re: @ Sign in TI Scripts

Post by tez »

Great, thanks so much Alan.

Regards
Terri
Post Reply