December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...