What just happened?

The Dimension Designer used in this example adds new attributes to the Sales Territory dimension. To create a new attribute, you can simply drag-and-drop it from the data source view, but sometimes the data source view doesn't contain the appropriate column, which forces you to change the data source view (in the next chapter, you will see how to make changes in the DSV).

You can also change the properties of the dimension attributes in the Dimension Structure tab. For example, we changed AttributeHierarchyVisible of Sales Territory Key to false, and as a result, this attribute was not shown directly in the browser. There are some properties and configurations for each attribute. The following list shows the most useful properties of attributes:

To run this example, you need to deploy the changes and the process again; this step is required after each change that you make in the metadata of the SSAS cube, dimension, or measures. For the next example, we will use the OrderBy and OrderBy Attribute properties to change the ordering of a dimension attribute.