forked from scrambldchannel/tm1-model-pony-music-backup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Phased Costs.rules
39 lines (34 loc) · 1.65 KB
/
Phased Costs.rules
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
#Region System
FEEDSTRINGS;
SKIPCHECK;
UNDEFVALS;
#EndRegion
#UNDEFVALS;
#Region C-Calculation rules: Dimension:Account
#Autogenerated CALC CONSOLIDATED 4163636F756E74
#Region Dimension:Account, Member:Rev per FTE
#Autogenerated MEMBERCALC CONSOLIDATED 5B4163636F756E745D2E5B52657620706572204654455D
['Account':'Rev per FTE']=C:(['Account':'4999']\['Account':'FTE']);
#EndRegion
#Region Dimension:Account, Member:Cost per FTE
#Autogenerated MEMBERCALC CONSOLIDATED 5B4163636F756E745D2E5B436F737420706572204654455D
['Account':'Cost per FTE']=C:(['Account':'TE']\['Account':'FTE']);
#EndRegion
#EndRegion
#Region N-Calculation rules: Dimension:Account
#Autogenerated CALC NUMERIC 4163636F756E74
#Region Dimension:Account, Member:Rev per FTE
#Autogenerated MEMBERCALC NUMERIC 5B4163636F756E745D2E5B52657620706572204654455D
['Account':'Rev per FTE']=N:(['Account':'4999']\['Account':'FTE']);
#EndRegion
#Region Dimension:Account, Member:Cost per FTE
#Autogenerated MEMBERCALC NUMERIC 5B4163636F756E745D2E5B436F737420706572204654455D
['Account':'Cost per FTE']=N:(['Account':'TE']\['Account':'FTE']);
#EndRegion
#EndRegion
FEEDERS;
#Region FEED The Income Statement
['6300','Spread Method']=>DB(IF(ATTRS('Version',!Version,'LinkVersion')@<>'','Income Statement',''),'local',!organization,!Year,'Year',!Account,!Version);
['6310','Spread Method']=>DB(IF(ATTRS('Version',!Version,'LinkVersion')@<>'','Income Statement',''),'local',!organization,!Year,'Year',!Account,!Version);
['6320','Spread Method']=>DB(IF(ATTRS('Version',!Version,'LinkVersion')@<>'','Income Statement',''),'local',!organization,!Year,'Year',!Account,!Version);
#EndRegion