Viewing Attributes in Dimension Designer
Attributes are created on dimension objects. You can view and configure attributes by using Dimension Designer in Microsoft SQL Server Analysis Services. The Attributes pane of the Dimension Structure tab of Dimension Designer lists the attributes that are in a dimension. Use this pane to add, remove, or configure attributes. You can also select attributes to use as a level in a new hierarchy or to add as a level in an existing hierarchy.
To view the attributes in a dimension, open Dimension Designer for the dimension. The Attributes pane of the Dimension Structure tab of the designer shows the attributes that are in the dimension. You can switch between a list, tree, or grid view by pointing to Show Attributes in on the Dimension menu of Business Intelligence Development Studio and then clicking one of the commands shown in the following table.
Show Attributes in |
Description |
---|---|
List |
Displays the attributes in list format. Right-click an attribute to delete it from the list, to rename the attribute, or to change the usage of the attribute. Use this view for building hierarchies. Attribute information and member properties are not visible. |
Tree |
Display the attributes in tree format, with the dimension as the top-level node in the tree. Expand an attribute to view attribute relationships for it or to create a new attribute relationship, by performing the following actions:
Use this view for viewing and creating member properties. You can also use this view to build hierarchies. |
Grid |
Display the attributes in grid format. The grid displays the following columns:
Click any row in the grid to view properties for that attribute. Use this view for creating and configuring attributes. |
In BI Development Studio, the icons shown in the following table mark attributes according to their usage.
Icon |
Attribute Usage |
---|---|
Regular or AccountType |
|
Key |
|
Parent |