Tm1 Rules
Posted: 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
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