2 Replies Latest reply: Jan 19, 2012 4:02 AM by ravimandre RSS

    How to get Organization hierarchy like dir->manager->teamLead->SSE->JSE

      Hi all,

       

      I am trying to make hierarchy let say for an organization where titles are  DIRECTOR, MANAGER, TEAM LEAD, SSE,JSE AND TRAINEE.

      using some dummy data for this . but not getting the right Hierarchy structure . its giving error in script .

      hierarchy should become like this 

       

       

                                                                  DIRECTOR

                                                                       |

                                                                   MANAGER

                                                                       |

                                                                   TEAM LEAD

                                                                      |

                                                                  SSE

                                                                      |

                                                                   JSE

                                                            

       

      can some one help me in this.

      following is the script that I am getting after using the Hierarchy while loading xls file.

       

      HIERARCHY(DIRECTOR, MANAGER, TEAMLEAD, TEST1, SSE, TEST2, /)
      LOAD DIRECTOR,
      MANAGER ,
      TEAMLEAD,
      SSE,
      JSE,
      TRAINEE
      FROM SHEET1

       

      Regards

      Ravindra Mandre