I have slight problem with linking the Hierarchies which I created to the Fact or Dimension. Just to paint the picture, I have four 4 fact tables Sales,Salesbudget, CustPayments and CustInvoice. The dimensions are Customers, Product,Area, Branch and CustomerClass.
I then created Hierarchy structure based on CustomerClass>>Region>>Branch (from Customer Table). So my question is how to link the hierarchy back to Fact or Dimension tables?