I've upgraded to AS2005 and i'd like to know how can i create this type of
dimension.
In AS2000 this was very simple, as many other things that in AS2005 aren't.
Can someone help me?

Thanks

You can refer to the Product dimension in the Adventure Works DW AS 2005
database - its snowflake schema is also described in BOL:

http://msdn2.microsoft.com/en-us/library/ms175439.aspx
Introduction to Dimensions
...
Dimension based on a Snowflake Schema Design

Frequently, a more complex structure is required because information
from multiple tables is required to define the dimension. In this
structure, called a snowflake schema, each dimension is based on
attributes from columns in multiple tables linked to each other and
ultimately to the fact table by primary key - foreign key relationships.
For example, the following diagram illustrates the tables required to
completely describe the Product dimension in the AdventureWorksDW sample
project:
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

They are called "Reference" dimensions now in AS2005. A Snowflake is
implemented by relating the inner table (intermediate table) between
the fact and the outer table (reference dimension). You can also join
the snowflaked tables together inside a Named Query and treat it like a
view and build a dimension off that. Hope this helps.

alejandro wrote: