I have a question about creating a dimension from a lookup table that holds
the lookup values for several fields in my fact table.

FACT TABLE
foreignkeyvalue1 (can hold values 1,2, or 3)
foreignkeyvalue2 (can hold values 1,2, or 3)
foreignkeyvalue3 (can hold values 1,2, or 3)

LOOKUP TABLE
1 = Low
2 = Medium
3 = High

Assuming that I want to keep the fact table flat, do I have to create 3
separate lookup tables to create 3 separate dimensions in a cube for the
three foreign keys, or is there a way to create 3 separate dimensions for
the three foreign keys off of the same lookup table?

When I create a dimension off of the LOOKUP TABLE for foreignkeyvalue1, I am
unable to get it to create another independent dimension off of the same
LOOKUP TABLE for foreignkeyvalue2.

ANYONE?

tx,
tim

The way to do this is to have three different SQL views for each dimension.
The three different SQL views can point to the same table, but since they're
different views you won't have join issues with different values in those
different columns in your fact table.

"Tim Chapla" wrote:

Thank you. I am pulling my head out of the sand right now. DUH!

"SQL McOLAP" <SQLMcOLAP (AT) discussions (DOT) microsoft.com> wrote