Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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?
PFA
Regards
BZ !
Hello again, I m still waiting for the response from anyone who can assist me.