Pro SQL Server 2012 BI Solutions by Randal Root & Caryn Mason

Author:Randal Root & Caryn Mason [Root, Randal & Mason, Caryn]
Language: eng
Format: epub
Tags: Enterprise Applications, Computers, Business Intelligence Tools, Database Management, Data Mining
ISBN: 9781430234883
Publisher: Apress
Published: 2012-09-12T04:00:00+00:00

Figure 9-35. The first two screens of the Dimension Wizard

The third option on the Dimension Wizard page is similar to the second. It generates a virtual time dimension table within the SSAS database, but not in the data warehouse. Although the table is not in the data warehouse, you still create a time dimension as if it was.

While this option is interesting, it is better to have a table in the data warehouse so that reports that work directly with the data warehouse can use it.

The fourth selection on this wizard page allows you to create one or more tables using templates. Microsoft supplies a number of templates, but you are free to create your own as well.

To create a template, make a data source view with your preferred dimension design. Then create a dimension based on the data source view and save the resulting XML file to the proper folder, usually C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Templates\olap\1033\Dimension Templates.

As with the time table options, each template you create can be reversed engineered by Visual Studio to generate SQL code. This code can then be used to create tables within the data warehouse. With this feature, you could technically create the dimensions in Visual Studio before you created a data warehouse. But like the previous option, it is interesting but not commonly used.

The most common option used is the initial default option. Once you have selected your option, click Next to proceed to the third page of the wizard.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.