Mosaic YAML Format Overview

The Mosaic YAML format is a highly structured, declarative configuration language userd to define semantic data models. It is a bridge between physical database tables and logical business concepts, enabling self-service analytics and reporting platforms (such as Strategy) to understand the data.

A complete Mosaic YAML file typically defines a Mosaic model and includes the following components:

• Global Properties & Model: Global properties of the data model, including versioning, localization, and the core model definition.

• Tables: Logical tables that map to physical database tables, including data pipelines and column definitions.

• Attributes: Business dimensions and descriptive fields (for example, Data, Product) used for grouping and filtering.

• Fact Metrics: Quantitative measures (for example, Sales, Cost) with aggregation functions and formatting.

• Metrics: Calculated measures derived from fact metrics, constants, or other metrics.

• Hierarchy and Relationships: Structural relationships between attributes that define how data rolls up.

• Security Filters: Row-level security rules that restrict data access based on user identity.

• Folders: Organizational grouping for model objects such as attributes and metrics.

• Links and External Models: References to attributes or metrics from other Mosaic models.

• ACL: Access Control Lists (ACL) define fine-grained permissions for user or group IDs on specific objects that control access rights such as Browse, Read, and Write.

• Translations: Internalization support that provides localized strings for names and descriptions across various locales, ensuring the model is accessible to global users.

See the following topics that describe each section of the YAML file, showcasing the fields, their types, and their purposes using a sample Call Center Daily Sales Analysis model.