Dynamic Hierarchy Structure

[er_mohit]

Hi Friends

M stuck off facing this problem. here's an example

like i have a table

LOAD * INLINE [

    Name, Flag

    A, 1

    B, 2

    C, 3

    D, 3

    E, 3

    F, 2

    G, 3

    H, 3

];

I want output as alike hierarchy wise on basis of flag

so, in pivot i want this

Level1 Level2 Level3

A           B       C

                      D

                      E

            F        G

                      H

here, when i expand A then it gives all data of Level2 and Level3

but when i expand Level2 F value it gives G and H in Level3

Any help will be appreciated.

[er_mohit]

Please help me here i want

in three separate field

Level1 gives value A

level2 gives B and F

Level 3 gives C,D,E,F,G,H

here in level2 if i select B then in Level3 gives C,D,E

when i select F value in Level2 then it gives F,G,H

or if can't possible please suggest me how to make Correlated flag in data source so, that it can give like this output

[nilo_pontes · Accepted solution]

Hi Mohit,

Please see if the attached file helps you.

You might want to take a look at this article as well: Hierarchies

Best Regards,

Nilo

[tresesco]

HIERARCHY(NodeID, ParentID, Node)

LOAD

  Flag as NodeID,

  Flag-1 as ParentID,

  Name as Node;

LOAD * INLINE [

    Name, Flag

    A, 1

    B, 2

    C, 3

    D, 3

    E, 3

    F, 2

    G, 3

    H, 3

];

PFA