Skip to Main Content
Microsoft® SQL Server® 2008 Analysis Services Step by Step
book

Microsoft® SQL Server® 2008 Analysis Services Step by Step

by Scott Cameron
April 2009
Beginner content levelBeginner
448 pages
14h 1m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Analysis Services Step by Step

Using the Wizard to Create a Cube

The Cube Wizard guides you through the process of selecting the fact table data and the dimensions that you bring together into a cube. In the Cube Wizard, you select a data source view. All of the fact and dimension tables for the cube must be in that data source view. You then identify the fact table columns that will be used to create measures in the cube. For each fact table, the wizard will create a measure group that contains the measures created from the columns in the table. In each measure group, you can also create a measure that counts the number of rows in the fact table. A cube requires at least one measure group that must contain at least one measure, but you most likely will choose to have several ...

Become 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,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed
Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Reed Jacobsen, Stacia Misner, Hitachi Consulting

Publisher Resources

ISBN: 9780735626201Supplemental ContentCatalog PageErrata