Create Semantic Model

Content-Type (Required)

String

Specifies media type of request body.

application/x-www-form-urlencoded

sessionid

String

The session ID is the token received from the login API.

Note: Session ID is required for token-based authentication.

–

type

String

Type of Semantic Model to create, which can be either Multidimensional or Single Table.

MULTIDIMENSIONAL: Creates a traditional OLAP Semantic Model from a Data Relationship Diagram (DRD). Requires json parameter with DRD reference.

SINGLE_TABLE: Creates a Semantic Model directly from a single database table. Requires name, dbName, connectionName, tableName, schemaName parameters.

Default: MULTIDIMENSIONAL

viewType

String

If Semantic Model type is SINGLE_TABLE, then this parameter specifies whether the view type should be Flat or Smart.

FLAT_VIEW: The Semantic Model will be designed as a flat table, where all source data columns are included as attributes within a single dimension.

SMART_VIEW: The system will intelligently identify measures and dimensions and create a more business-friendly Semantic Model view. This model will organise source data fields into measures, attributes, and hierarchies based on their data types.

Default: FLAT_VIEW

name

String

Name of the Semantic Model to be created. This name is used to create the underlying entities associated with the Semantic Model. If a Semantic Model with the same name already exists in the specified folder, the system automatically generates a unique name.

Note: Required only when type=SINGLE_TABLE.

–

folderName

String

Name of the folder in which the Semantic Model will be created. If the folder does not exist, a new folder with the provided name is created. Note: Required only when type=SINGLE_TABLE.

–

connectionName

String

Name of the connection to be used for the Dataset.

Note: Required only when type=SINGLE_TABLE.

–

dbName

String

Name of the database to be used in the Dataset.

Note: Required only when type=SINGLE_TABLE.

–

tableName

String

Name of the table to be used in the Dataset.

Note: Required only when type=SINGLE_TABLE.

–

schemaName

String

Name of the schema to be used in the Dataset.

Note: Required only when type=SINGLE_TABLE.

–

json (Required)

String

JSON definition containing the Semantic Model structure and configuration details.

Note: An example JSON definition is provided under the Resources section below.

–

401

Authorization information is missing or invalid.

404

Connection, database, schema, or table not found.

412

Precondition failed. Required parameter missing.

500

Internal Server Error