0 Replies Latest reply on Jan 2, 2014 3:21 PM by Ava

    OBIEE 11G - Creation of Parent child hirarchy

    Ava

      We need to create a parent child hierarchy for city wise branches

       

      In our DB we have only one table - the same we need to consider as Dimension & Fact.

       

      Attributes as follows:

       

      customername, customernumber, accountnumber,city, branch, financialyear,financialquarter

       

      We do not have primary key on above structure.

       

      But we can get unique composite key by combining: Account Number, city  & branch attributes.

       

      Bangalore

      - MG Road

      - Silk Board

      - Marthahalli

      - Tinfactory

      - silkboard

       

      Hyderabad

      - Ammerpet

      - Abids

      - Koti

       

      Regards,

      Ava