Dimensional attributes contain information about the Dimension object. Attributes are exposed in the cube to provide the ability to navigate and aggregate the data in the cube. User defined hierarchies can be built over attributes to provide drill paths through the data and to aid aggregation.
The properties of an attribute can be displayed by right clicking an attribute in the middle pane and choosing Properties. The following dialog is displayed:
Fields | Description |
---|---|
Dimension Name | A read only field to display the dimension which the attribute is related to. |
Internal Attribute Name | The name of the attribute in WhereScape RED. |
Published Name | The name of the attribute created in Analysis Services. |
Description | A business name that is stored in WhereScape RED for documentation and stored in the Analysis Services metadata. |
Estimated Count | Specifies the number of members in the attribute. This number is either the amount last counted by Analysis Services or a user provided estimate of the member count. |
Member Names Unique | Indicates whether member names are unique for this attribute. |
Hierarchy Visible | Indicates whether the attribute hierarchy is visible to client applications. Even if the attribute hierarchy is not visible, it can still be used in a user defined hierarchy. |
Hierarchy Enabled | Indicates whether an attribute hierarchy is enabled for this attribute. If the attribute hierarchy is not enabled, then the attribute cannot be used in a user defined hierarchy. |
Hierarchy Optimized State | Specifies the level of optimization applied to the attribute hierarchy. |
Hierarchy Display Folder | Attribute hierarchies can be organized into user-defined folders to view and manage these attributes within the Analysis Services user interface more easily. Enter the display folder name. Note One object can be in multiple display folders, for example: Dimension Attributes and Dimension Hierarchies have the same display folder drop-down list. |
Order by | Specifies the method used to order the members of the attribute. |
Order by attribute | Specifies the attribute used to order the members of the attribute hierarchy. |
Type | Specifies the type of information contained by the attribute. |
Usage | Specifies the usage of the attribute. |
Key Column | Specifies the details of the binding to the column containing the member key. |
Name Column | Specifies the details of the binding to the column containing the member name. |
Value Column | Specifies the details of the binding to the column containing the member value. Note Using the Value Column OLAP cube attribute setting for Excel date filtering |
To View Attributes | To view the list of Attributes, right-click on an OLAP Dimension in the left pane and select Display Attributes. |
To Add an Attribute |
|
To Delete an Attribute | Display the Attributes in the middle pane, right-click the Attribute and then select Delete. |