ATTRS in TI

Post Reply
par3
Posts: 82
Joined: Tue Sep 09, 2008 7:05 am

ATTRS in TI

Post by par3 »

Hi Guys/Ladies,

I am trying to use ATTRS in a TI Process but it keeps telling me I can't use dimension names in a process.

Can anyone help?

Here is TI code...

IF(ATTRS('GL Account',!Account,'Type') = 'Inc');

PY = P/Year * -1;
CY = C/Year * -1;
Budget = Budget * -1;

GL Account - Dimension
!Account - All Accounts
Type - Atrribute I want to call.


Thanx!
Andy Key
MVP
Posts: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: ATTRS in TI

Post by Andy Key »

You can't use the ! notation in TI.

Do you have the Account as a variable in the TI?

If so, just use the variable name instead of !Account.
Andy Key
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: ATTRS in TI

Post by John Hobson »

My you have to act fast to get a reply in here don't you? :D
John Hobson
The Planning Factory
User avatar
Michel Zijlema
Site Admin
Posts: 712
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: ATTRS in TI

Post by Michel Zijlema »

IF(ATTRS('GL Account',!Account,'Type') = 'Inc');
Another thing: you need to use '@=' instead of '=' when you're comparing string data.

Michel
Post Reply