Dimensions
Financial Workspace dimensions — members, hierarchies, cross-references
CPM
Standard dimensions
6
Standard Financial Workspace dimensions — shared across all workspaces
| Code | Business name | Members | Structure | Used in |
|---|---|---|---|---|
SCENARIO
|
Scenario | 26 | 1 grouping | 11 datasets · 11 fields |
PERIODO
|
Period | 12 | — | 10 datasets · 10 fields |
AZIENDA
|
Entity;fr=Entité | 18 | 3 hierarchies | 12 datasets · 12 fields |
VALUTA
|
Currency | 10 | — | 6 datasets · 6 fields |
CONTO
|
Account;fr=Compte | 529 | 2 hierarchies | 1 dataset · 1 field |
CATEGORIA
|
Category | 40 | 1 grouping | 6 datasets · 6 fields |
CPM
Consolidation
Variation/Detail types and account grouping rules used in consolidation
| Code | Business name | Members | Structure |
|---|---|---|---|
CAUSALE |
Variation / Detail types | 13 | 1 grouping |
CONTROLLO |
Control Groups | 48 | — hierarchies |
CPM
Custom dimensions (DEST)
5
Project-specific DEST dimensions — custom analytical axes added to the data model
| Code | Business name | Members | Structure | Used in |
|---|---|---|---|---|
DEST1
|
Cost Centers;fr=Centre cout | 28 | 4 hierarchies | 3 datasets · 3 fields |
DEST2
|
Products;fr=Produit | 108 | 4 hierarchies | 7 datasets · 8 fields |
DEST3
|
Customers;fr=Clients | 44 | 7 hierarchies | — |
DEST4
|
Employees;fr=Employés | 121 | 5 hierarchies | 3 datasets · 5 fields |
DEST5
|
Miscellaneous;it=Miscellaneous | 60 | 7 hierarchies | — |
Analytical
Analytical dimensions
9
Project-specific ED_ dimensions used in AIH/DTP datasets
| Code | Business name | Members | Structure | Used in |
|---|---|---|---|---|
ED_CHANNEL
|
Channel | 30 | 1 hierarchy | 5 datasets · 5 fields |
ED_COMPETITOR
|
Competitor | 81 | — | 6 datasets · 6 fields |
ED_DRG
|
Drg | 481 | 2 hierarchies | 3 datasets · 3 fields |
ED_IP
|
Ip | 13 | 1 hierarchy | 3 datasets · 3 fields |
ED_PATIENT
|
Patient | 63 | 2 hierarchies | — |
ED_OWNER
|
Owner | 276 | — | 5 datasets · 5 fields |
ED_LEAD_SOURCE
|
Lead_source | 30 | — | — |
ED_PROSPECT
|
Prospect | 4650 | 4 hierarchies | 8 datasets · 14 fields |
ED_STAGE
|
Stage | 12 | 1 hierarchy | 5 datasets · 5 fields |