Form A100 · Tagetik Application

Properties source
Sources: prospetto

Code: A100
Description: Executive Strategy Cockpit
Web opening: NV
Type flags: Input
Groups: A1 Long Range Planning

Structure source
Sources: prospetto_xml

Form parameters

▾

Dimension		Hierarchy		Parameter
`AZIENDA` Entity;fr=Entité	›	010 All Entities	›	ENTITY_NODE Choose a Region

Strategic Plan

Template00 · 7 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

▾

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	›	ENTITY_NODE	param

Rows

CONTOAccount;fr=Compte 5

▾

Hierarchy / FST		Item	Type
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
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1000 Geo Split	fixed
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1005 Seasonality Pattern	fixed

Cols

CATEGORIACategory 2

▾

Hierarchy / FST		Item	Type	TGKML
—	›	010 Original Data	fixed
—	›	100 Strat Plan	fixed

SCENARIOScenario 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

Seasonality 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

LUNPER 1

▾

LUN_1

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

CONTOAccount;fr=Compte 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1245 LRP Seasonality %	fixed

Rows

PERIODOPeriod 4

▾

03, 06, 09, 12

Cols

CATEGORIACategory 2

▾

Hierarchy / FST		Item	Type	TGKML
—	›	010 Original Data	fixed
—	›	100 Strat Plan	fixed

SCENARIOScenario 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

DEST5Miscellaneous;it=Miscellaneous 4

▾

Hierarchy / FST		Item	Type
—	›	NA NA	fixed
—	›	ST_01 Baseline	fixed
—	›	ST_10 Q1 Push	fixed
—	›	ST_11 Q4 Push	fixed

Strategy Impact 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

TIP 1

▾

Hierarchy / FST		Item	Type	TGKML
—	›	TIP_O	fixed

PERIODOPeriod 1

▾

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

LUNPER 1

▾

LUN_0

Rows

CONTOAccount;fr=Compte 3

▾

Hierarchy / FST		Item	Type
010 All Accounts - BS, PL & Statistical Accounts	›	50010 Product Sales	fixed
010 All Accounts - BS, PL & Statistical Accounts	›	55010 Inbound Freight	fixed
010 All Accounts - BS, PL & Statistical Accounts	›	90010 Income Taxes	fixed

Cols

CATEGORIACategory 2

▾

Hierarchy / FST		Item	Type	TGKML
—	›	010 Original Data	fixed
—	›	100 Strat Plan	fixed

SCENARIOScenario 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

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

▾

LUNPER 1

▾

LUN_1

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

Rows

CONTOAccount;fr=Compte 6

▾

Hierarchy / FST		Item	Type
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
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1025 Fuel Price	fixed
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1030 Fiscal Pressure	fixed

Cols

CATEGORIACategory 2

▾

Hierarchy / FST		Item	Type	TGKML
—	›	010 Original Data	fixed
—	›	100 Strat Plan	fixed

SCENARIOScenario 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

DEST5Miscellaneous;it=Miscellaneous 4

▾

Hierarchy / FST		Item	Type
—	›	NA NA	fixed
—	›	ST_01 Baseline	fixed
—	›	ST_02 High	fixed
—	›	ST_03 Low	fixed

Geo Split 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

▾

LUNPER 1

▾

LUN_1

CONTOAccount;fr=Compte 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1250 LRP Geo Split	fixed

Rows

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

Cols

CATEGORIACategory 2

▾

Hierarchy / FST		Item	Type	TGKML
—	›	010 Original Data	fixed
—	›	100 Strat Plan	fixed

SCENARIOScenario 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

DEST5Miscellaneous;it=Miscellaneous 4

▾

Hierarchy / FST		Item	Type
—	›	NA NA	fixed
—	›	ST_01 Baseline	fixed
—	›	ST_08 East Coast Exp.	fixed
—	›	ST_09 West Coast Exp.	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

▾

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

Rows

CONTOAccount;fr=Compte 3

▾

Hierarchy / FST		Item	Type
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 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

DEST5Miscellaneous;it=Miscellaneous 4

▾

Hierarchy / FST		Item	Type
—	›	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

▾

AZIENDAEntity;fr=Entité 1

▾

Hierarchy / FST		Item	Type	TGKML
010 All Entities	›	ENTITY_NODE	param

Rows

CONTOAccount;fr=Compte 5

▾

Hierarchy / FST		Item	Type
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_1060 Marketing	fixed
010 All Accounts - BS, PL & Statistical Accounts	›	ST_1065 Commissions	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 4

▾

Hierarchy / FST		Item	Type
—	›	2018ACT 2018 Actuals	fixed
—	›	2019SP 2019 Strat Plan	fixed
—	›	2020SP 2020 Strat Plan	fixed
—	›	2021SP 2021 Strat Plan	fixed

DEST5Miscellaneous;it=Miscellaneous 4

▾

Hierarchy / FST		Item	Type
—	›	NA NA	fixed
—	›	ST_01 Baseline	fixed
—	›	ST_06 Cost Cutting	fixed
—	›	ST_07 R&D Outsourcing	fixed

Queries 5 source
Sources: prospetto_xml

Dropdown - Geo Split

SQL DE_GE

▾

SELECT 'Baseline' as Product union
SELECT 'East Coast Exp.' union
SELECT 'West Coast Exp.'

Dropdown - Sales Assumptions

SQL DD_SA

▾

SELECT 'Baseline' as Product union
SELECT 'Boost Local Sales' union
SELECT 'Inc. Distributors'

Dropdown - Expense Assumptions

SQL DE_EA

▾

SELECT 'Baseline' as Product union
SELECT 'Cost Cutting' union
SELECT 'R&D Outsourcing'

Dropdown - Macroeconomics

SQL DD_ME

▾

SELECT 'Baseline' as Product union
SELECT 'High' union
SELECT 'Low'

Dropdown - Seasonality

SQL DE_SE

▾

SELECT 'Baseline' as Product union
SELECT 'Q1 Push' union
SELECT 'Q4 Push'

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

Workflow	Phase	Task list	Task description
`LRP` Long Range Planning Process	`A` Strategic Planning	`010` Default WF	Regional Targets

A100

Properties sourceSources: prospetto

Structure sourceSources: prospetto_xml Expand all Collapse all

Queries 5 sourceSources: prospetto_xml

Used in Workflows 1 sourceSources: RACCOLTA_AZIENDA_WFM, WFM task list

`A100`

Properties source
Sources: prospetto

Structure source
Sources: prospetto_xml

Queries 5 source
Sources: prospetto_xml

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