Creating simple dimensions
The Analysis Services dimension allows examining data across a specific business vertical. For example, the Product dimension allows managers to see which products generated the most revenue, and the Geography dimension helps determine the most profitable regions. Each dimension is based on a corresponding table or view in the relational data source; dimension table's columns will correspond to SSAS dimension attributes. Analysis Services allows creation of very simple as well as very complex dimension structures. There are many dimension and attribute properties which let us customize each dimension to meet specific business requirements. Let's begin by creating a simple dimension and then working our way through more complex ones.
Getting ready
To complete this recipe, we must have at least one data source view with necessary tables, views, named queries, and named calculations.
How to do it...
To create a dimension perform the following steps:
Right-click on the...
