Global Dimensional Data Store (DDS)
See the Global DDS tables.
Customer 360 Star
The Customer 360 star allows customers to use one table to gain a complete understanding of all activities and results for an account by combining CRM activities and sales data with global standardized dimensions.
The following dimensions and their related sources are loaded when the Load Global Dimensions (jb_global_LoadDimensions__v) job is run:
| Global Dimension Table | Global ODS Data and Source Data |
|---|---|
|
dim_global_demographic__v |
demographic_gbl_ods__v (Network) |
|
dim_global_product__v |
crm_product_gbl_ods__v (CRM) |
|
dim_global_territory__v |
territory_gbl_ods__v (Align) |
|
dim_global_activity__v |
|
|
dim_global_channel__v |
|
|
dim_date__v |
Standard dim_date__v table |
The following facts and their related sources are loaded when the Load Customer 360 Fact (jb_global_LoadFactAccount360__v) is run:
|
Global Customer 360 Facts |
Global ODS Data and Source Data |
|---|---|
|
Activities |
cir_gbl_ods__v (CRM) |
|
Sales |
csr_gbl_ods__v (Symphony Non-Retail) |
The following CRM Activities are captured in the Customer 360 star:
- Calls
- Call Details
- Call Key Messages
- Remote Meeting Attendees
- Sent Emails
- Event Attendees
- Event Management Attendee
- Medical Inquiry
The following diagram displays the data sources that must be populated to use the Customer 360 star:
