Many to Many Dimensions


  • Hi ,

    I have Data in the following format in .

    AS I understand MBU - BU Is a regular dimension and BU to order no is Many to Many dimension and Order No to PO No is a Many to Many dimension .

    I am looking at a Bridge Table or Factless Fact for Order No and BU and Another Bridge Table for PO NO and Order No.

    Would that be correct. Please help.

    MBU BU Order No PO No
    Software MS 001 P01
    Software MS 002 P01
    Software SAP 001 P02
    Manufacturing Cars 003 P03



    sabato 7 aprile 2012 14:12