Many to Many Dimension RRS feed

  • Question

  • 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 hav a Bridge Table or Factless Fact for Order No and BU and Another Bridge Table for PO NO and Order No.

    When i try to browse a Data by Order No the Same Value repeats across Order No. How do i fix this ?

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



    Saturday, April 7, 2012 2:15 PM