The Model section displays information about the data model.
By default, the model is given the same name as the database that was given in the Data Flow. The model name can be changed here.
By default, the database name and the date and time that the Data Flow was created are displayed under Description. The description can be changed here. This description will be visible to users when opening the data model in Discover.
The default measure is the measure that is automatically added to queries and calculations when no measure is specified. To set the default measure. open the drop-down and select the required measure.
In this example, the default measure is Sales. This means that any time a dimension hierarchy is added to query, the value shown will be Sales unless a different measure is selected. Likewise, when custom calculations are defined, they will be based on Sales unless other measures are given.
Blank Member Caption
This is the caption that will be displayed for any blank members in the data model. By default, the blank member caption is 2 dashes "--" but can be changed as required.
Any empty member values will be replaced with the string that's given as the blank member caption.
From the 'Culture' drop-down, select the relevant language and region to apply the appropriate formatting to the model. For example, selecting Hebrew will ensure that any commas run right to left instead of left to right.
From the 'Translation Language' multi-select drop-down, select the relevant language(s) to define translations. A list of all languages appears in the drop-down to choose from. Once selected, translations for the metadata and attribute mappings must be defined.
The Data Flow section displays information about the ETL, including the data flow and the target.
The name of the data flow.
This is the target where the data model will be stored. This is the target that was connected to the Data Flow.
If the target set in the Data Flow is a database on a server, you'll have the option to select a Tabular model target. If the Data Flow target is an SQL server, you'll be able to select either a Virtual or Tabular model target.
MS Tabular Model
This option is seen only if the Data Flow destination is an SQL server. Select Tabular to load the model's data and metadata into a Tabular target. Some Data Flow functions, like Machine Learning, cannot be directly loaded into a Tabular target. To remedy this, users can select a different server type as the target in the Data Flow, and then select a Tabular target from Data Model. The ETL is loaded into the target chosen in the Data Flow, and from there data model's data and metadata is loaded into the Tabular target.
- Click here to learn more.
The summary displays some statistics about the data model. It displays the number of data sources used to create the data model, and the number of tables, columns, and measures in the data model.