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%'