Defining Dimensions and Hierarchies
You are now ready to start defining dimensions and hierarchies to your database. Dimensions are the building blocks for cubes in SSAS. You start by right-clicking the Dimensions object in the Solution Explorer (or choosing Project, New Dimension). You can create a new (standard) dimension or define a dimension that is linked to another SSAS cube or database.
For this example, you will be creating three new cube dimensions, based on the dimension tables you have in your data source views (Time_Dimension, Prod_Dimension, Geo_Dimension). When you choose the New Dimension option, you are welcomed to the Dimension Wizard. You need to build the new dimensions by using your data source views. As you can see in Figure ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
