Strategy One

Global Properties and Model

The root level of the YAML file defines the global properties of the data model, including versioning, localization, and the core model definition.

Global Properties

Field Type Description Example

version

String

The YAML schema version.

"1.0"

metadataLocale

String

Locale for metadata fields.

"en-US"

dateNumberLocale

String

Locale for formatting dates and numbers.

"en-US"
model

Array

Contains the core model definition (usually a single object).

[ { information: {...} } ]

fingerprint

String

A fingerprint (checksum) that can be used to verify the integrity of the exported data and detect if changes have been made since the export.

"127476cd..."

Model Object Properties

The model array primary object contains the following fields:

Field Type Description Example

information

Object

Core identity of the model. Contains primaryLocale (the locale of the user who created the object), objectId (the unique 32-character hex identifier for the object), subType (for example, report_emma_cube), name, and description.

{ name: "Call Center Daily Sales Analysis" }

acl

Object

Access Control List defining permissions for different user/group IDs (for more information, see Access Control List).

{ "0AB3BC2...": { granted: 0, denied: 255 } }

translations

Object

Localized strings for the model's name and description (for more information, see Translations).

{ name: { translationValues: { 1033: ... } } }
dataServeMode

String

Specifies how data is served.

"in_memory"

enableWrangleRecommendations

Boolean

Enables data wrangling suggestions.

true

enableAutoHierarchyRelationships

Boolean

Automatically infers hierarchy relationships.

true

enableAutoGenerateFriendlyNames Boolean Enables automatically generated user-friendly object names. true

enableAutoMergeAttributeColumns

Boolean

Enables related attribute columns to automatically merge.

true

enableAutoCreateMultiFormAttributes Boolean Enables automatically created attributes with multiple forms. true

sampling

Object

Data loading sampling configuration.

{ type: "first", rowCount: 1000 }

partition Object Data partitioning configuration. { mode: "automatic", number: 4 }

autoJoin

Boolean

Automatically joins tables based on relationships.

true

tables Array List of logical tables in the model. See Table Array.

attributes

Array

List of business dimensions.

See Attributes Array.

factMetrics Array List of fact-based numeric measures. See Fact Metrics Array.

metrics

Array

List of derived calculations.

See Metrics Array.

hierarchy Array Defines relationships between attributes. See Hierarchy.

links

Array

Connections to external Mosaic models.

See Links and External Models.

externalDataModels Array External Mosaic models registry. See Links and External Models.

securityFilters

Array

Defines row-level security rules.

See Security Filters Array.

folders Array Organizational structure for model objects. See Folders Array.

Example

See the following global properties file example:

Copy
version: "1.0"
metadataLocale: "en-US"
dateNumberLocale: "en-US"
model:
- information:
    primaryLocale: "en-US"
    objectId: "5CB60D2F25D6461185108F47BE10E66C"
    subType: "report_emma_cube"
    name: "Call Center Daily Sales Analysis"
    description: "Analyzing daily sales performance"
  acl:
    "0AB3BC27425A061AEFCEEF9868D5E69A":
      granted: 0
      denied: 255
      inheritable: false
  translations:
    name:
      targetName: "Object Name"
      translationValues:
        1033:
          translation: "Call Center Daily Sales Analysis"
  dataServeMode: "in_memory"
  enableWrangleRecommendations: true
  enableAutoHierarchyRelationships: true
  enableAutoGenerateFriendlyNames: true
  enableAutoMergeAttributeColumns: true
  enableAutoCreateMultiFormAttributes: true
  sampling:
    type: "first"
    rowCount: 1000
  partition:
    mode: "automatic"
    number: 4
  autoJoin: true
  tables: ...
  attributes: ...
  factMetrics: ...
  metrics: ...
  hierarchy: ...
  links: ...
  externalDataModels: ...
  securityFilters: ...
  folders: ...
fingerprint: "127476cd979acb99554ec2555325097bb733c7896b73b8e454ae40c3866cb655"