E231

Best/Worst Performers
Input

Properties source
Sources: prospetto

Code
E231
Description
Best/Worst Performers
Web opening
NV
Type flags
Input
Groups
E23 Sales Analytics

Structure source
Sources: prospetto_xml

Form parameters
3
Dimension Hierarchy Parameter
AZIENDA
Entity;fr=Entité
010
All Entities
03
Choose an Entity
PERIODO
Period
$PER_P
SCENARIO
Scenario
$
Scenarios
SCE_REP
Scenarios for CY
Form filters
5 dims
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
TIP 1
Hierarchy / FST Item Type TGKML
TIP_O fixed
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
LUNPER 1
LUN_0
SCENARIOScenario 1
Hierarchy / FST Item Type TGKML
$ Scenarios SCE_REP param
Revenue Analysis
Template00 · 7 matrices
Matrix00 CPM
Rows
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Cols
PERIODOPeriod 1
$PER_P
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
Bottom 5 Entities CPM
Rows
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P
Top 5 Entities CPM
Rows
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P
Top 5 Customers CPM
Filters
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Rows
DEST3Customers;fr=Clients 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P
Top 5 Products CPM
Filters
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Rows
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P
Bottom 5 Products CPM
Filters
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Rows
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P
Bottom 5 Customers CPM
Filters
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
Rows
DEST3Customers;fr=Clients 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 010 Sales Revenue fixed
PERIODOPeriod 1
$PER_P

Queries 2 source
Sources: prospetto_xml

# of Cust
SQL Query00
SELECT COUNT(*) FROM DEST3 WHERE COD_DEST3 LIKE 'CM%'
# of Prod
SQL Query01
SELECT COUNT(*) FROM DEST2 WHERE COD_DEST2 LIKE 'PD%'