Create, Save and Update Semantic Model JSON Examples

Overview

This guide provides JSON examples for creating and configuring Semantic Models using the Semantic Model APIs.

It includes a Complete Semantic Model JSON example that demonstrates the full set of options available for creating and configuring a Semantic Model. The APIs also support a Simplified Semantic Model JSON format that allows you to define multidimensional models with dimensions, hierarchies, measures, and advanced configurations.

Understanding Complete JSON Format

The Complete Semantic Model JSON demonstrates the full set of configuration options available for creating and configuring a Semantic Model. It can be used as a reference for the request body of the Create Semantic Model, Save Semantic Model, and Update Semantic Model APIs.

Understanding Simplified JSON Format

The Simplified Semantic Model JSON in the use case sections represents the minimum required structure for creating a Semantic Model. It serves as a simplified starting point for creating Semantic Models.

The use cases in this guide demonstrate how additional capabilities can be enabled by adding or modifying specific sections of this base configuration.

On this page:

1 Overview
2 Complete Semantic Model JSON Example
3 Use Case 1: Regular Dimension
4 Use Case 2: Predefined Time Type Dimension
5 Use Case 3: Parent-Child Hierarchy
6 Use Case 4: Alternate Hierarchy
7 Use Case 5: Dimension Attributes
8 Use Case 6: Custom Rollup
9 Use Case 7: Base Measure
10 Use Case 8: Calculated Measure

The example illustrates the minimum required structure of a Semantic Model:

{
  "name": "semantic_model_name",
  "id" : "semantic_model_id"
  "folderName": "folder_name",
  "folderId": "folder_id",
  "specific": {
    "attrs": {
      "drdName": "dataset_relationship_name",
      "drdId": "dataset_relationship_id",
      "modelType": "BASE",
      "rawDataQuerying": "Disable",
      "rawDataConnectionMode": "MANUAL",
      "rawDataConnectionName": "connection_name"
    },
    "smObject": {
      "dimensions": [
        {
          "name": "dimension_name",
          "materialize": "yes",
          "scdType": "0",
          "uniqueName": "dimension unique_name",
          "id": "",
          "type": "Regular",
          "hierarchies": [
            {
              "qualifyMembers": { "type": "ALL_PARENTS", "value": "" },
              "materialize": "yes",
              "uniqueName": "DIMENSION_HIERARCHY_19",
              "name": "hierarchy_name",
              "defaultMemberUniqueName": "",
              "displayFolder": "",
              "isDefault": true,
              "levels": [
                {
                  "dataField": {
                    "queryName": "dataset_name",
                    "content": "datafield_name",
                    "queryId": "1574246587640912719111976284_0"
                  },
                  "dateDataType": "",
                  "dateFormat": "",
                  "format": "",
                  "fieldDataType": "VARCHAR",
                  "dataType": "CHAR",
                  "name": "level_name",
                  "uniqueName": "DIMENSION_LEVEL_368124447385"
                }
              ]
            }
          ]
        }
      ],
      "measures": {
        "measure": [
          {
            "dataField": {
              "queryName": "fact_table_name",
              "content": "datafield_name",
              "queryId": "15742469109458127015058139963310_3"
            },
            "isDefault": true,
            "materialize": "YES",
            "id": "measure_unique_id",
            "formatType": "2",
            "dataType": "NUMBER",
            "summaryFunction": "1",
            "actualSummaryFunction": "1",
            "format": {
              "useDefault": "0",
              "content": "#,##0.00"
            },
            "name": "measure_name",
            "uniqueName": "measure_unique_name"
          }

        ]
      },
      "measureGroups": {
        "measureGroup": [
          {
            "measureId": [
              "MEASURE_76",
            ],
            "materialize": "YES",
            "name": "Sales Measures"
          }
        ]
      }  
    }
  },
  "common": {
    "compatibilityVersion": "3",
    "desc": "description",
    "tags": "comma_separated_tags"
  }
}