Hi,

Suppose I have a fact table...and one of the fields in this table is
ProductID.

Now suppose I have a Product Dimension which also has ProductID as one
of the fields.

Question: In the Cube Editor, is there any difference between the
following approaches:

1) I click on the ProductID field in the FACT table and drag it to the
ProductID field in the PRODUCT table

2) I click on the ProductID field in the PRODUCT table and drag it to
the ProductID field in the FACT table


I have been told then the logic is similar to when designing a query in
SQL server I.e. If I want to link a table called Customers with a table
called Orders (and assume both have a field called CustID), I should
always click on the CHILD table and drag it towards the parent table
(I.e. click on the CustID in the orders table and then drag it towards
the CustID field in the Customers table). Is this correct? Does it make
a difference?

Thanks.
P.S.
I realize that the last paragraph should be posted to sqlprogramming
group but the reason for posting it here is cause I thought it's related
to the first part of the question.

In the cube editor, there is no difference between the
two approaches.

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

Thanks.

And is this also valid (i.e. there is no difference) when linking 2 tables in query designer in SQL?

Thanks.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...