forked from scrambldchannel/tm1-model-pony-music-backup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Base Sales Forecast.rules
50 lines (46 loc) · 3.12 KB
/
Base Sales Forecast.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
#Region System
FEEDSTRINGS;
SKIPCHECK;
#EndRegion
#Region N-Calculation rules: Dimension:Existing Stores Revenue
#Autogenerated CALC NUMERIC 4578697374696E672053746F72657320526576656E7565
#Region Dimension:Existing Stores Revenue, Member:ESRWA
#Autogenerated MEMBERCALC NUMERIC 5B4578697374696E672053746F72657320526576656E75655D2E5B45535257415D
#@AutoGenerated
['Existing Stores Revenue':{'ESRWA'}]=N:(['Existing Stores Revenue':'Existing Stores Revenue']*['Existing Stores Revenue':'GROSS MARGIN %'])\100;
#EndRegion
#EndRegion
#Region C-Calculation rules: Dimension:Existing Stores Revenue
#Autogenerated CALC CONSOLIDATED 4578697374696E672053746F72657320526576656E7565
#Region Dimension:Existing Stores Revenue, Member:GROSS MARGIN %
#Autogenerated MEMBERCALC CONSOLIDATED 5B4578697374696E672053746F72657320526576656E75655D2E5B47524F5353204D415247494E20255D
#@AutoGenerated
['Existing Stores Revenue':{'GROSS MARGIN %'}]=C:(['Existing Stores Revenue':'ESRWA']*100)\['Existing Stores Revenue':'Existing Stores Revenue'];
#EndRegion
#EndRegion
#Region N-Calculation rules: Dimension:Retailers
#Autogenerated CALC NUMERIC 52657461696C657273
#Region Dimension:Retailers, Member:All
#Autogenerated MEMBERCALC NUMERIC 5B52657461696C6572735D2E5B416C6C5D
#@AutoGenerated
['Retailers':{'All'}]=N:['Retailers':'Department Store']+['Retailers':'Direct Marketing']+['Retailers':'Equipment Rental Store']+['Retailers':'Eyewear Store']+['Retailers':'Golf Shop']+['Retailers':'Outdoors Shop']+['Retailers':'Sports Store']+['Retailers':'Warehouse Store'];
#EndRegion
#EndRegion
FEEDERS;
#Region Automatically generated feeders
#Autogenerated AUTOFEEDERS
['Existing Stores Revenue':'Cash Discount'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'Cash Discount');
['Existing Stores Revenue':'Returns and Allowances'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'Returns and Allowances');
['Existing Stores Revenue':'Volume Discount'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'Volume Discount');
['Existing Stores Revenue':'Freight'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'Freight');
['Existing Stores Revenue':'Existing Stores Revenue'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'Existing Stores Revenue');
['Existing Stores Revenue':'GROSS MARGIN %'] => DB('Gross Margin Calculation', !Retailers, !Country and Region,
!Store Type, !Month, !Budget version, 'GROSS MARGIN %');
['Retailers':{'Eyewear Store', 'Outdoors Shop', 'Sports Store', 'Direct Marketing', 'Department Store', 'Golf Shop', 'Warehouse Store', 'Equipment Rental Store'}, 'Existing Stores Revenue':{'GROSS MARGIN %', 'Freight', 'Cash Discount', 'Volume Discount', 'Returns and Allowances', 'Existing Stores Revenue'}] => ['Retailers':'All'];
['Existing Stores Revenue':'Existing Stores Revenue'] => ['Existing Stores Revenue':'ESRWA'];
#EndRegion