6 Replies Latest reply: Dec 11, 2013 4:16 AM by Bhavin Shindroja RSS

    Parent Child Dimension

      Hi all

       

      Im trying build a dimension from a table which has a parent child relationship.

       

      The tables includes the following parent child:

       

      Parent

      Child

      Description

      NULL

      TRUST

      Trust Cost Pools

       

      PBI

      Patient based income

      TRUST

      Expense

      Trust Expenditure

      TRUST

      Income

      Trust Income

      Expense

      10

      Ward Costs

      Income

      CT_OPI

      Radiology OP Income

       

       

      So the results returned should be:

       

      TRUST

            Expense

                 10

            Income

                 CT_OPI


      How can i build this into my script?


      Many Thanks