Column Properties (SSAS Tabular)

This topic describes tabular model column properties.

Sections in this topic:

• Column Properties

• To configure column property settings

Column Properties

Basic

Property	Default Setting	Description
Column Name		The name of the column as it is stored in the model and as it is displayed in a reporting client field list.
Data Format	Automatically determined during import.	Specifies the display format to use for the data in this column. This property has the following options: General Decimal Number Whole Number Currency Percentage Scientific After you set a data format, you can set properties that are specific to each format. For example, if you choose the Currency format, you can set the number of visible decimal places, choose the thousands separator, and choose the currency symbol. If the column values contain images, see Representative Image.
Data Type	Automatically determined during import.	Specifies the data type for all values in the column.
Description		A text description for the column. In certain reporting clients, if an end-user places the cursor over this column in the field list, the description appears as a tooltip.
Hidden	False	Specifies whether the column is hidden from reporting client field lists. Set this property to True to hide this column in the display. For example, columns that contain identifiers or keys are typically not useful to the end user. If you hide a column from the reporting client, the field is not suppressed in the model data. The field is still visible if you create a query against the model. A hidden column can still be used for grouping or sorting. The Hidden property does not provide any form of data security. To secure data, use row filters in Roles. For more information, see Roles (SSAS Tabular).
Sort By Column		Specifies another column to sort the values in this column. A relationship must exist between the two columns. This value must be the name of an existing column. You cannot specify a formula or measure.

Reporting Properties

For detailed information on setting Power View table behavior properties, see Configure Table Behavior Properties for Power View Reports (SSAS Tabular).

Property	Default Setting	Description
Default Image	False	Specifies which column provides an image that represents the row data (for example, a photo ID in an employee record).
Default Label	False	Specifies which column provides a display name to represent row data (for example, employee name in an employee record).
Image URL/Data Category (SP1)	False	Specifies the value in this column as a hyperlink to an image on a server. For example: https://localhost/images/image1.jpg.
Keep Unique Rows	False	Specifies which columns provide values that should be treated as unique even if they are duplicates (for example, employee first name and last name, for cases where two or more employees share the same name).
Row Identifier	False	Specifies a column that contains only unique values, allowing that column to be used as an internal grouping key.
Summarize By	Default	Specifies reporting client tools apply the aggregate function SUM for column calculations when this column is added to a Field list. To change the default calculation, select it from the dropdown list. This property applies only to columns of type that can be aggregated.
Table Detail Position	No Default Field Set	Specifies this column or measure can be added to a set of fields from a single table to enhance the table visualization experience in a reporting client.

To configure column property settings

1. In the model designer, in a table, select a column.

2. In the Properties window, click on a property, and then type a value or click the down arrow to select a setting option.

Zobacz także

Koncepcje

Power View Reporting Properties (SSAS Tabular)

Hide or Freeze Columns (SSAS Tabular)

Add Columns to a Table (SSAS Tabular)