DB_000

Existing Store Sales Plan
Input 1 workflow

Properties source
Sources: prospetto

Code
DB_000
Description
Existing Store Sales Plan
Web opening
NV
Type flags
Input
Groups
10 Retail Model

Structure source
Sources: prospetto_xml

Form parameters
3
▾
Dimension Hierarchy Parameter
AZIENDA
Entity;fr=Entité 		› 010
All Entities 		› 03
Choose an Entity
DEST1
Cost Centers;fr=Centre cout 		› 020
Stores by Status 		› $DEST1_020_P
SCENARIO
Scenario 		› $
Scenarios 		› SCE_BDG
Scenario for Budget
Form filters
2 dims
▾
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
020 Stores by Status › $DEST1_020_P param
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 03 param
Store Revenue Planning
Template00 · 3 matrices
▾
Store Attributes CPM
▾
Filters
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
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
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 045 Retail fixed
Rows
CONTOAccount;fr=Compte 2
▾
Hierarchy / FST Item Type TGKML
— › ST_970 Square Footage fixed
— › ST_975 Store Info fixed
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
— › TIP_DES fixed
Cols
PERIODOPeriod 1
▾
12
Financial Output CPM
▾
Filters
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
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 045 Retail fixed
LUNPER 1
▾
LUN_1
Rows
CONTOAccount;fr=Compte 9
▾
Hierarchy / FST Item Type TGKML
— › ST_930 Store Traffic fixed
— › ST_935 Customer Conversion Rate % fixed
— › ST_940 # of Transactions fixed
— › 50010 Product Sales fixed
— › ST_955 Manual Adjustment fixed
— › ST_960 Operational Coef fixed
— › ST_950 Discounts % fixed
— › 50020 Sales Discounts fixed
— › ST_965 Revenue by Sqft fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
Cols
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
DEST5Miscellaneous;it=Miscellaneous 6
▾
Hierarchy / FST Item Type TGKML
— › WK_1 Week 1 fixed
— › WK_2 Week 2 fixed
— › WK_3 Week 3 fixed
— › WK_4 Week 4 fixed
— › NA NA fixed
— › WK_5 Week 5 fixed
Store Modelling CPM
▾
Filters
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
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 045 Retail fixed
LUNPER 1
▾
LUN_1
Rows
CONTOAccount;fr=Compte 9
▾
Hierarchy / FST Item Type TGKML
— › ST_930 Store Traffic fixed
— › ST_935 Customer Conversion Rate % fixed
— › ST_940 # of Transactions fixed
— › 50010 Product Sales fixed
— › ST_955 Manual Adjustment fixed
— › ST_960 Operational Coef fixed
— › ST_950 Discounts % fixed
— › 50020 Sales Discounts fixed
— › ST_965 Revenue by Sqft fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
Cols
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
PERIODOPeriod 2
▾
12, 11
DEST5Miscellaneous;it=Miscellaneous 3
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
— › LI_010 1 fixed
— › LI_015 2 fixed

Used in Workflows 1 source
Sources: RACCOLTA_AZIENDA_WFM, WFM task list

Workflow Phase Task list Task description
BDG Annual Budget Workflow 10_RV Revenue / COGS Plan REVR Retail Revenue Planning Plan Existing Location Sales