Book Image

Getting Started with SQL Server 2012 Cube Development

Book Image

Getting Started with SQL Server 2012 Cube Development

Overview of this book

Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting Started with SQL Server 2012 Cube Development teaches you through clear step-by-step exercises to create business intelligence solutions using Analysis Services. The knowledge gained through these practical examples can immediately be applied to your real-world problems. Getting Started with SQL Server 2012 Cube Development begins with an introduction to business intelligence and Analysis Services, the world's most-used cube engine. Guiding you through easy-to-understand examples to become a cube developer. Learn how to create a cube including all the advanced features such as KPIs, calculated measures, and time intelligence. Security and performance tuning will also be explored. You will learn how to perform and automate core tasks like deployment and processing. The main focus is on multidimensional cubes, but the creation of in-memory models will also be covered. You will learn everything you need to get started with cube development using SQL Server 2012.
Table of Contents (17 chapters)
Getting Started with SQL Server 2012 Cube Development
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating additional dimensions and adding them to the cube


Now let's go back to creating more dimensions. In this case, we will add the Product dimension. The Product dimension is stored in three different tables in the data source view. The DimProduct table contains all the product rows, the DimProductSubcategory table contains the subcategories, and the DimProductCategory table contains the major category list of the products. To create the Product dimension, follow these steps:

  1. In the Solution Explorer window, right-click on Dimensions and choose New Dimension....

  2. Choose Use an existing table and click on Next.

  3. Use the Adventure Works DW2012 data source view and select DimProduct as the main table. The key column will be ProductKey and the name column should be EnglishProductName; after this has been done click on Next.

    Tip

    Whenever you have a dimension that is stored in several tables you always start with the table that is closest to the fact table.

  4. As you can see, the outer tables according...