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
Tm1 Rules
- PavoGa
- MVP
- Posts: 622
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Tm1 Rules
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.
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
Cleveland, TN