I have a dimension that I just can’t get to relate to my fact table. Here is
the setup:

Customer Table
Customer_no (pk)

Order Table
Order_no (pk)
Customer_no

Lineitem Table
Lineseq_no (pk)
Order_no

Sublineitem Table (Fact)
Sli_no (pk)
Lineseq_no

I don’t know if this is even possible, but I am trying to get the customer
dimension to relate to the fact table but can’t get it to work. I have
created dimensions for customer, order, and lineitem with lineitem as a
regular relationship type and everything else as a referenced relationship
type. Is this the wrong way to go about it or am I just missing something
simple? My end goal is to take totals sales from sublineitem and break it out
by customer attributes like Gender and eventually break it out by postal code
from my address table which is joined to customer. Thanks for the help,

--
Marty

Marty,

referenced dimension are not intended to solve the problem that you
have not designed a star schema.
I don't know if you can use referenced dimensions in a chain like your
scenario, but what you should be do is to have a fact table with
customers directly related to it. If you really don't want (or cannot)
create a real star schema, than you can solve the problem by creating a
view that join Order/LineItem/SubLineItem and using that as fact table.

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi

Marty ha scritto: