In this article (http://www.dbmsmag.com/9809d05.html)
Kimball talks about implementing hierarchies using a
helper table (Customer Organizations).

If I understand this correctly - the helper table will
have a record for relationship between a node and each
ancestor (parent, grand-parent.).

I do not know is it possible to use this kind of schema in
AS. What type of dimension would that be? It's probably
not Parent-Child because we would have more then one
table. Therefore, it must be 'Snowflake Schema'. Does
anybody have similar experience? Is there a book or
article on this topic?

The reason that I am interested in this schema is because
I need to implement a schema that supports hierarchy of
organizations with multiple parents and SCD2.

Snowflake - preciously - my favourite - not parent-child

You have a table for each level which are linked in dimension editor - so

level 1 table = link to fact table
level 2 table = link to level 1 table
and so forht

in dimension editor you link these two tables - in cube editor you insert
existing dimension and it will automatically link level 1 table with fact
table.

if you want to use surrogate keys it can be a bit more complex.

michael

"Misko Ecim" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:192d01c49c2c$8259e500$a401280a (AT) phx (DOT) gbl...