I have a table where the child can belong to multiple parents. It deals with
books- a book can be part of multiple shrink-wrapped packages(parents). I
cannot use the parent-child dimension as they can only be used in cases
where the child can belong to only one parent. There are nested packages
too, making the levels variable. Only the parent-levels have facts.

What type of dimension would you recommend in such a scenario?
Thanks in advance.

ld

Depending on the granularity of your fact table, you might consider using
books as a standard dimension and the shrink-wrapped data as a value in your
fact table to provide the same type of functionality as an order number
would for order details (I think this is called a degenerate dimension)

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"LD" <ldhal (AT) hotmail (DOT) com> wrote