A recursive table contains information in one column that is a parent or child of information in a second column. Essbase Integration Server can build Essbase outline hierarchies from a recursive source table.
When creating a hierarchy from a recursive table, follow these guidelines:
To associate aliases or user-defined attributes (UDA) with members created from a recursive table, ensure the column with which you associate the alias or UDA is fully defined.
When creating an OLAP model, join the recursive table to itself.
When creating a metaoutline, select the parent or child column you want to filter on as a member level in the metaoutline.