Configuring multiple hierarchy on dimension

    Configuring multiple hierarchy on dimension

    I have a dimension named "Customers" that have attributes:
    Person
    Campany
    Steve
    Roby
    00625
    00637
    00654
    POP & CO
    MIDDLE's CUN

    I want to create an hierarchy like:
    00625
    -->Person
    ------>Steve
    -->Company
    ------>POP & CO
    00637
    -->Person
    ------>Roby
    -->Company
    00654
    -->Person
    -->Company
    ------>MIDDLE'S CUN

    Thks in advance.
    You can do this by having Customer leaf members having 2 attributes Person & Company.
    But with attributes Palo's analysis across attributes are limited, but still would be a better design.

    Else you would want to merge hierarchies then take care of IDs
    00625
    -->00625_Person
    ------>Steve
    -->00625_Company
    ------>POP & CO
    00637
    -->00637_Person
    ------>Roy
    -->00637_Company
    ------->Jedox

    Best regards,
    Noel.