A303

Top Down Rolling Forecast
Input

Properties source
Sources: prospetto

Code
A303
Description
Top Down Rolling Forecast
Web opening
C
Type flags
Input
Groups
A3 Monthly Forecasting

Structure source
Sources: prospetto_xml

Form parameters
2
▾
Dimension Hierarchy Parameter
SCENARIO
Scenario 		› $
Scenarios 		› SCE_FCT
Scenario for Forecast
AZIENDA
Entity;fr=Entité 		› 010
All Entities 		› 03
Choose an Entity
Forecast
Template00 · 6 matrices
▾
Select Strategy CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
PERIODOPeriod 1
▾
12
LUNPER 1
▾
LUN_1
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
Rows
CONTOAccount;fr=Compte 3
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › ST_985 Macroeconomics fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_990 Sales Assumptions fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_995 Expense Assumptions fixed
Cols
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 100 Strat Plan fixed
SCENARIOScenario 2
▾
Hierarchy / FST Item Type TGKML
— › 2019FCT_02 2019 February Forecast fixed
— › 2019FCT_02N 2019 February Forecast Next fixed
Forecast Calculate CPM
▾
Filters
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › 010 fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
LUNPER 1
▾
LUN_1
Rows
CONTOAccount;fr=Compte 4
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 100 fixed
010 All Accounts - BS, PL & Statistical Accounts › 200 fixed
010 All Accounts - BS, PL & Statistical Accounts › 300 fixed
010 All Accounts - BS, PL & Statistical Accounts › 400 fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_FCT param
Cols
PERIODOPeriod 1
▾
|
Rolling Forecast CPM
▾
Filters
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › 010 fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
LUNPER 1
▾
LUN_1
Rows
CONTOAccount;fr=Compte 5
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 100 fixed
010 All Accounts - BS, PL & Statistical Accounts › 200 fixed
010 All Accounts - BS, PL & Statistical Accounts › 300 fixed
010 All Accounts - BS, PL & Statistical Accounts › 400 fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_664 Retirement 1 fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_FCT param
Cols
PERIODOPeriod 1
▾
|
Macroeconomics CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
PERIODOPeriod 1
▾
12
LUNPER 1
▾
LUN_1
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
Rows
CONTOAccount;fr=Compte 4
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › ST_1010 Inflation fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1015 Interest Rate fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1075 Unemployment fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1020 Equity Market Shift fixed
Cols
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
— › 100 Strat Plan fixed
SCENARIOScenario 3
▾
Hierarchy / FST Item Type TGKML
— › 2018ACT 2018 Actuals fixed
— › 2019FCT_02 2019 February Forecast fixed
— › 2019FCT_03 2019 March Forecast fixed
DEST5Miscellaneous;it=Miscellaneous 4
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
— › ST_01 Baseline fixed
— › ST_02 High fixed
— › ST_03 Low fixed
Sales Assumptions CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
PERIODOPeriod 1
▾
12
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
Rows
CONTOAccount;fr=Compte 3
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › ST_1035 Direct Channel fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1040 Indirect Channel fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1045 COS fixed
Cols
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
— › 100 Strat Plan fixed
LUNPER 1
▾
LUN_1
SCENARIOScenario 3
▾
Hierarchy / FST Item Type TGKML
— › 2018ACT 2018 Actuals fixed
— › 2019FCT_02 2019 February Forecast fixed
— › 2019FCT_03 2019 March Forecast fixed
DEST5Miscellaneous;it=Miscellaneous 4
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
— › ST_01 Baseline fixed
— › ST_04 Boost Local Sales fixed
— › ST_05 Inc. Distributors fixed
Expense Control CPM
▾
Filters
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
— › CC_500 Generic Cost Center fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
— › PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › EE_500 Generic Employee fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
PERIODOPeriod 1
▾
12
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
Rows
CONTOAccount;fr=Compte 5
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › ST_1050 Salary & Wages fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1055 R&D fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1065 Commissions fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1060 Marketing fixed
010 All Accounts - BS, PL & Statistical Accounts › ST_1070 Travel fixed
Cols
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
— › 100 Strat Plan fixed
LUNPER 1
▾
LUN_1
SCENARIOScenario 3
▾
Hierarchy / FST Item Type TGKML
— › 2018ACT 2018 Actuals fixed
— › 2019FCT_02 2019 February Forecast fixed
— › 2019FCT_03 2019 March Forecast fixed
DEST5Miscellaneous;it=Miscellaneous 4
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
— › ST_01 Baseline fixed
— › ST_06 Cost Cutting fixed
— › ST_07 R&D Outsourcing fixed