Member attributes

Member attributes help to explain or describe a member in a dimension.

For example, suppose that you have a dimension that lists cars. You could have attributes that describe fuel type, engine size or type, and number of doors.

You can show attributes in a table and you can select which attributes you want to show. For information about how to show member attributes in the cube view, see Show member attributes in the cube view. You can sort on attributes, and you can convert attributes into a hierarchy. Converting attributes into hierarchies is useful if you want to group dimension members by attribute. For example, suppose that you want to display cars that have a gasoline engine, you can add an attribute called Engine type, then create a hierarchy from the Engine type attribute. You would then be able to group members by Engine type attribute in the view.

You add member attributes in the dimension editor.