Working with a Standard Snowflake Dimension

The Product dimension comes from a set of dimension tables, one for each level of the Product hierarchy. The Dimension Wizard asks you directly if you have multiple (snowflake) tables for the dimension. In the Dimension Editor, you must add the additional dimension tables yourself. In this section, you’ll create a new version of the Product dimension you created in Chapter 2. This time, however, you’ll use the Dimension Editor exclusively and you’ll utilize properties of a dimension that are not available by using the Dimension Wizard.

Create a Dimension from Multiple Tables

From within the Dimension Editor, you can create a new dimension in two ways: by using the Dimension Wizard or by using multiple ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step 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.