Tm1 Rules

Post Reply
DYNA
Posts: 5
Joined: Mon Jul 29, 2019 10:09 am
OLAP Product: PLANNING ANALYTICS (TM1)
Version: 2.0.6
Excel Version: Excel for office 365
Location: SOUTH AFRICA

Tm1 Rules

Post by DYNA » Mon Aug 05, 2019 8:54 am

Hi guys

I'm new to Tm1, and I would kindly ask for an explanation for the following rules:

Part A
[{'Budget Year 2019/20','Budget Year 2017/18','Budget Year 2018/19'}] =S:
IF(
(ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'MappedBU')
@=
ATTRS('RE_BusinessUnit',Dimnm('RE_BusinessUnit',Dimix('RE_BusinessUnit',!RE_BusinessUnit)),'MappedBU'))
& (ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'Access') @<> 'LOCK'),
'WRITE',IF(
(ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'LEAF')
@= 'Yes') ,'READ','WRITE')
);


Part B
[{'Forecast 2016/17'}] =S:
IF(
(ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'MappedBU')
@=
ATTRS('RE_BusinessUnit',Dimnm('RE_BusinessUnit',Dimix('RE_BusinessUnit',!RE_BusinessUnit)),'MappedBU'))
& (ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'Access') @<> 'LOCK'),
'WRITE',IF(
(ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'LEAF')
@= 'Yes') ,if( (ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'AccType') @= 'HR') &
(ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'MappedBU')
@=
ATTRS('RE_BusinessUnit',Dimnm('RE_BusinessUnit',Dimix('RE_BusinessUnit',!RE_BusinessUnit)),'MappedBU'))
,'WRITE','READ'),'WRITE')
);

Kindly assist.

Thank you

User avatar
PavoGa
Community Contributor
Posts: 359
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: Tm1 Rules

Post by PavoGa » Mon Aug 05, 2019 12:13 pm

If I may, this is too general a question. If you have a specific issue with rule or a problem you're not sure how to resolve, this is a good place. But this site is not intended to be TM1 101 training.

See the proper rule IBM manual for the version you are using. Another excellent source is the Bedrock white paper on rule development. Good luck.
Ty
Cleveland, TN

Post Reply