Enable Tabular Model
Enables generation of a SQL Server Analysis Services Tabular model and project for the dimensions and facts of a project during Build. A project scoped value overrides the instance level value. When disabled or blank, no Tabular output is produced.
The build evaluates this setting for each project. The project's target connection must have the system type MSSQL, SQLDB or SQLDW. For any other system type the build reports a warning and emits no model for that project. The Server and Database settings set the deployment target of the generated project, and Compatibility Level sets the level of the model.
When to Change This Setting
Enable it for a project whose dimensions and facts should also be delivered as an Analysis Services Tabular model.
Related Settings
| Setting | Interaction |
|---|---|
| Server | The Analysis Services server the generated project deploys to |
| Database | The Analysis Services database the generated project deploys to |
| Compatibility Level | The compatibility level of the generated model |
| Enable Semantic Model | Turns on the separate semantic model (TMDL) output |
Notes
- This setting is part of the Analysis Services settings category.
- The default value for this setting is
N.