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!
ATTRS in TI
-
- MVP
- Posts: 352
- 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
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.
Do you have the Account as a variable in the TI?
If so, just use the variable name instead of !Account.
Andy Key
- 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
My you have to act fast to get a reply in here don't you? 

John Hobson
The Planning Factory
The Planning Factory
- 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
Another thing: you need to use '@=' instead of '=' when you're comparing string data.IF(ATTRS('GL Account',!Account,'Type') = 'Inc');
Michel