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.