forked from scrambldchannel/tm1-model-pony-music-backup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Line Item Detail.rules
72 lines (65 loc) · 4.05 KB
/
Line Item Detail.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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
#Region System
FEEDSTRINGS;
SKIPCHECK;
UNDEFVALS;
#EndRegion
#UNDEFVALS;
#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
#Region N-Calculation rules: Dimension:LineItemDetail
#Autogenerated CALC NUMERIC 4C696E654974656D44657461696C
#Region Dimension:LineItemDetail, Member:Total
#Autogenerated MEMBERCALC NUMERIC 5B4C696E654974656D44657461696C5D2E5B546F74616C5D
['LineItemDetail':'Total']=N:IF((['LineItemDetail':'Factor B']=0),['LineItemDetail':'Factor A'],(['LineItemDetail':'Factor A']*['LineItemDetail':'Factor B']));
#EndRegion
#EndRegion
#Region C-Calculation rules: Dimension:LineItemDetail
#Autogenerated CALC CONSOLIDATED 4C696E654974656D44657461696C
#Region Dimension:LineItemDetail, Member:Factor B
#Autogenerated MEMBERCALC CONSOLIDATED 5B4C696E654974656D44657461696C5D2E5B466163746F7220425D
['LineItemDetail':'Factor B']=C:0;
#EndRegion
#EndRegion
#Region C-Calculation rules: Dimension:Account
#Autogenerated CALC CONSOLIDATED 4163636F756E74
#Region Dimension:Account, Member:FTE
#Autogenerated MEMBERCALC CONSOLIDATED 5B4163636F756E745D2E5B4654455D
['Month':{'Year', 'YTD', 'Q1', 'Q2', 'Q3', 'Q4', 'Jan YTD', 'Feb YTD', 'Mar YTD', 'Apr YTD', 'May YTD', 'Jun YTD', 'Jul YTD', 'Aug YTD', 'Oct YTD', 'Nov YTD', 'Dec YTD', 'Sep YTD'}, 'Account':{'FTE'}]=C:IF(DIMIX('Month', ATTRS('Month', !Month, 'lastper
iod'))>0,
DB('Line Item Detail', !organization, 'FTE', !LineItemList, !Year, !Version, !LineItemDetail, ATTRS('Month', !Month, 'lastperiod')),
DB('Line Item Detail', !organization, 'FTE', !LineItemList, !Year, !Version, !LineItemDetail, ELCOMP('Month', !Month, ELCOMPN('Month', !Month))));
#EndRegion
#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
#Region Dimension:Account, Member:Square Footage
#Autogenerated MEMBERCALC CONSOLIDATED 5B4163636F756E745D2E5B53717561726520466F6F746167655D
['Month':{'Year', 'YTD', 'Q1', 'Q2', 'Q3', 'Q4', 'Jan YTD', 'Feb YTD', 'Mar YTD', 'Apr YTD', 'May YTD', 'Jun YTD', 'Jul YTD', 'Aug YTD', 'Oct YTD', 'Nov YTD', 'Dec YTD', 'Sep YTD'}, 'Account':{'Square Footage'}]=C:IF(DIMIX('Month', ATTRS('Month', !Mont
h, 'lastperiod'))>0,
DB('Line Item Detail', !organization, 'Square Footage', !LineItemList, !Year, !Version, !LineItemDetail, ATTRS('Month', !Month, 'lastperiod')),
DB('Line Item Detail', !organization, 'Square Footage', !LineItemList, !Year, !Version, !LineItemDetail, ELCOMP('Month', !Month, ELCOMPN('Month', !Month))));
#EndRegion
#Region Dimension:Account, Member:Server Space
#Autogenerated MEMBERCALC CONSOLIDATED 5B4163636F756E745D2E5B5365727665722053706163655D
['Month':{'Year', 'YTD', 'Q1', 'Q2', 'Q3', 'Q4', 'Jan YTD', 'Feb YTD', 'Mar YTD', 'Apr YTD', 'May YTD', 'Jun YTD', 'Jul YTD', 'Aug YTD', 'Oct YTD', 'Nov YTD', 'Dec YTD', 'Sep YTD'}, 'Account':{'Server Space'}]=C:IF(DIMIX('Month', ATTRS('Month', !Month,
'lastperiod'))>0,
DB('Line Item Detail', !organization, 'Server Space', !LineItemList, !Year, !Version, !LineItemDetail, ATTRS('Month', !Month, 'lastperiod')),
DB('Line Item Detail', !organization, 'Server Space', !LineItemList, !Year, !Version, !LineItemDetail, ELCOMP('Month', !Month, ELCOMPN('Month', !Month))));
#EndRegion
#EndRegion
FEEDERS;
['Item']=>['LineItemDetail':'Total'];