Model table

The DEPM_MOD_MODEL table is a logical unit grouping tables, table queries, cubes and dimensions.

The model can be used for UI purposes, or for modeling operations such as Create Model to OLAP. This creates all dimensions and cubes that are part of the model.

Name Definition
Name nvarchar(50) NOT NULL; PK
Caption nvarchar(150) NULL
PreserveManualAddedObjects Bool NOT NULL
Application nvarchar(50) NULL
DataConnection nvarchar(50) NULL
Connection nvarchar(50) NULL
DefaultSchema nvarchar(40) NULL

PreserveManualAddedObjects controls whether additional dimensions and cubes that have been created are deleted or ignored during publishing.

Application is the unique name of the application.

DataConnection is the unique name of the data connection.

Connection is the data connection string of the data connection.

DefaultSchema is not used yet.