SMML Elements: Subject Area

The SMML subject area element corresponds to the subject area schema in the presentation layer of a semantic model. The subject area schema contains subject area objects and elements.

subjectArea Elements

  • name (required property) — The name of the subject area.

  • description — The description of the subject area.

  • tags — The keywords assigned to this object. This element corresponds to the Tags field.

  • sourceBusinessModel (required property) — References the business model for this subject area.

  • implicitFactColumn — References the implicit fact column for this subject area, if one has been set. This column is used to specify a default join path between dimension tables when there are several possible alternatives or contexts.

  • alternateNames — Alternate names assigned to this object. This element corresponds to the Alternate Names field.

  • hideIfTrue — An expression that controls whether this subject area is visible in Oracle Analytics. See Expression Elements.

  • tableOrder — References the order of the tables that belong to the subject area.

  • permissions — Permissions defined for this object. See Permission Elements.

  • localization — Localized names for presentation layer subject areas and their descriptions.

TableOrder Elements

  • name (required property) — The name of the presentation table.

  • children — List of tables nested under the presentation table.

Children Elements

  • name (required property) — The name of the child presentation table.

  • children — List of tables nested under the table.

Syntax

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "$ref": "#/definitions/subjectArea",
    "definitions": {
        "subjectArea": {
            "type": "object",
            "additionalProperties": false,
            "properties": {
                "name": {
                    "type": "string"
                },
                "description": {
                    "type": "string"
                },
                "tags": {
                    "type": "array",
                    "items": {
                        "type": "string"
                    }
                },
                "sourceBusinessModel": {
                    "type": "string",
                    "rawType": "businessModel"
                },
                "implicitFactColumn": {
                    "type": "string",
                    "rawType": "logicalColumn"
                },
                "alternateNames": {
                    "type": "array",
                    "items": {
                        "type": "string"
                    }
                },
                "hideIfTrue": {
                    "$ref": "common_schemas#/definitions/Expression"
                },
                "tableOrder": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/TableOrder"
                    }
                },
                "permissions": {
                    "type": "array",
                    "items": {
                        "$ref": "common_schemas#/definitions/Permission"
                    }
                },
                "localization": {
                    "$ref": "common_schemas#/definitions/Localization"
                }
            },
            "required": [
                "name",
                "sourceBusinessModel"
            ],
            "title": "SubjectArea"
        },
        "TableOrder": {
            "type": "object",
            "additionalProperties": false,
            "properties": {
                "name": {
                    "type": "string"
                },
                "children": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Child"
                    }
                }
            },
            "required": [
                "name"
            ],
            "title": "TableOrder"
        },
        "Child": {
            "type": "object",
            "additionalProperties": false,
            "properties": {
                "name": {
                    "type": "string"
                },
                "children": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Child"
                    }
                }
            },
            "required": [
                "name"
            ],
            "title": "Child"
        }
    }
}