2 Replies Latest reply: Jul 31, 2018 8:12 AM by Aruna dabba RSS

    Hierarchical / Org chart dataset

    Jurien Groot

        I have the following dataset as an example. My total set is +/- 2500 rows with our org chart. It contains unique rows that lead up to a hierarchical model. Is there an easy way to drill to the various lines and see who reports to who? Or is the only way to do that having a multi dimensional model, with Peter being level 1 as a dimension, Klaas en Marie as level 2 being a dimension etc..

       

      IDReports_ToLevel
      0_Peter
      1_Klaas0_Peter1
      2_Bart1_Klaas2
      3_Marie0_Peter1
      4_Ellen3_Marie2
      5_Sander2_Bart3
      6_Moniek2_Bart3
      7_Kees6_Moniek4
      8_Seb3_Marie2
      9_Luis7_Kees5
      10_Monica4_Ellen3