Display attributes provide additional information to describe a dimension. For example, for the dimension customer, attributes might include country of the customer, contact person at the customer and email address of customer.
Display attributes are useful to the business user who can choose to display one or more attributes in the analytical query result alongside the dimension, to further explain each dimension value.
The analytical query developer can define the display attributes that should be displayed in the initial query result. The business user can remove these display attributes from the analytical query result at run-time, or even add those attributes that were not included, but are available in the star schema.
Here is the code used to define the default display attributes:
Remember to define the position of the attribute's text. In our case, the name of the airport appears after the airport code.
Note
You cannot aggregate measures using a display attribute. To achieve this, you must include the attribute in the cube view.Watch the video to learn how to define display attributes: