Change Properties in a Data Source View (Analysis Services)

 

Applies To: SQL Server 2016

After defining a data source view using the Data Source View Wizard and adding tables, views, named calculations, and named queries to the data source view, you may want to change properties related to:

  • Data source view matching criteria

  • Advanced data source view options

  • Object names

  • Object metadata

You can also view object metadata retrieved from the data source that you cannot modify.

Data source view properties, other than a description of the data source view, are set by the Data Source View Wizard when you initially define the data source view. The following table lists and describes the properties of a data source view.

System_CAPS_ICON_note.jpg Note


The Properties pane shows properties for the .dsv file as well as the DSV object. To view the properties of the object, double-click it in Solution Explorer. The Properties will update to reflect the properties you see in the following table.

PropertyDescription
Data SourceSpecifies the data source within the data source view whose properties you are viewing
DescriptionSpecifies a description of the data source view
NameSpecifies the name of the data source view that appears in Solution Explorer or the Analysis Services database. You can change the data source view name here or in Solution Explorer.
NameMatchingCriteriaThe name matching criteria for the data source. The default is (none) if primary key - foreign key relationships were detected by the Data Source View Wizard. Regardless of whether this property was set by the Data Source View Wizard, you can specify a value here. If database relationships exist and you specify name matching criteria, both will be used to infer relationships between existing tables and newly added tables.
RetrieveRelationshipsSpecifies whether relationships are retrieved from the database. Default is True.
SchemaRestrictionSpecifies the restrictions, if any, on the schemas retrieved from a data source. By default, no schema restrictions exist.

DataTable properties are the properties of tables, views, and named queries in a data source view. These properties are set when any of these objects is added to the data source view. The following table lists and describes the properties of DataTable objects in a data source view.

PropertyDescription
AllowChangesDuringGenerationSpecifies whether the Schema Generation Wizard has permission to overwrite a data source view table during regeneration. This property will only exist on tables initially generated by the Schema Generation Wizard. For more information, see Understanding Incremental Generation.
DataSourceSpecifies the data source for the object. You cannot edit this property.
DescriptionSpecifies the description for the table, view or named query. If the underlying database table or view had a description stored as an extended property, this value appears. You can edit this property.
FriendlyNameSpecifies a name for the table or view that is easier for users to understand or more relevant to the subject area. By default, the FriendlyName property of a table or view is the same as the Name property of the table or view. The FriendlyName property is used by OLAP and data mining objects when defining object names based on tables or views. You can edit this property.
NameSpecifies the name of the underlying table or view, or the name of the named query. The Name property is used by OLAP and data mining objects when defining object names based on named queries. This property is only editable for named queries.
QueryDefinitionSpecifies the named query definition. This property is only applicable to named queries and is not directly editable. To edit this property, you edit the named query itself.
SchemaSpecify the database schema applicable to the table, view or named query. This property is not editable.
TableTypeSpecifies the type of table for the table, view or named query. This property is not editable.

DataColumn properties are the properties of columns in tables, views, and named queries in a data source view. These properties are set when any of these objects is added to the data source view, either from the underlying table or view, from a named query, or as defined by a named calculation. The following table lists and describes the properties of DataColumn objects in a data source view.

PropertyDescription
AllowNullSpecifies the nullability property of the column based on the column in the underlying table, value or named query. This property is not editable.
DataTypeSpecifies the data type of the column based on the column in the underlying table, value or named query. This property is not directly editable. However, if you need to change the data type of a column from a table or view, replace the table with a named query that converts the column to the desired data type.
DateTimeModeSpecifies the date serialization format for DateTime columns. The default value is UnspecifiedLocal. This property is editable.
DescriptionSpecifies the description for the column. If the underlying database column had a description stored as an extended property, this value appears. You can edit this property.
FriendlyNameSpecifies the name for a column from a table or view that is easier for users to understand or more relevant to the subject area. By default, the FriendlyName property of a column from a table or view is the same as the Name property of the column. The FriendlyName property is used by OLAP and data mining objects when defining attributes based on columns from tables or views. You can edit this property.
LengthSpecifies the maximum length of the column, based on the data in the column in the underlying table or view.
NameSpecifies the name of the underlying column, or the name of the named calculation. The Name property is used by OLAP and data mining objects when defining attributes based on named calculations. This property is only editable for named calculations.

Data Source Views in Multidimensional Models
Work with Diagrams in Data Source View Designer (Analysis Services)

Community Additions

ADD
Show: