Understand the C360 Semantic Model

The C360 Semantic Model

The model provides a unified view across various Salesforce clouds, such as Sales, Service, Marketing, and Commerce. The SDM is also extensible. It allows the core model to be extended to meet specific industry or domain needs while maintaining alignment with the core structure.

Key Benefits

Key Benefits include:

• Consistent, Unified Metrics: Provides a single, trusted view of key business performance indicators across Sales, Service, Marketing, and Commerce clouds.
• Accelerated Insights: Helps users quickly analyze data across clouds without rebuilding models from scratch.
• Enables Intelligent Workflows: Facilitates smarter automated processes and actions with consistent data.
• Extensibility: The SDM allows the core model to be extended to meet specific industry or domain needs while maintaining alignment with the core structure.

Components of the C360 Semantic Model

The C360 Semantic Model integrates Salesforce cloud standard DMOs into a unified model, providing consistent cross-cloud metrics in a centralized location. It is powered by Data 360, making sure providing unified access and accelerated time to market.

The model’s core components leverage three key features– Standard Tables, Shared Tables, and Logical Views.

• Standard Fact Tables: These tables capture metrics and measures, such as Campaigns, Leads, Opportunities, Orders, Revenue, and Cases. They support different granularities, including daily, monthly, or transactional-level data.
• Standard Dimension Tables: These tables define business entities like customers, products, users, and regions, and include hierarchical relationships. For example, a product is a part of category and a brand.
• Shared tables or shared dimensions: Accounts, individuals, or users are examples that support cross-cloud insights. You can analyze metrics from different business areas, such as sales, service, marketing, and commerce using these common dimensions. Examples of common tables include Account, Account Contact, Product and Product hierarchy, Individual, User, and Date.
• Logical Views: These views manage duplicate objects, unions, joins, or custom SQL.

The specific DMOs for C360 Semantic Model ‌includes a selection of objects from Sales, Service, Marketing, and Commerce Clouds, as well as common tables/dimensions shared across these clouds. The metrics are created as calculated fields (calculated dimensions and measures).