Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to create into my cross table, used to import data from Excel File, the below load inline to setup a hierarchy between the indicators:
The Inline:
The Load Cross Table:
The final Table, here i would like to create the table Hierarchy here:
Thanks you in advance for your help,
Sébastien.
Try to create an INLINE table with pairs of adjacent nodes, parent / child relationsship.
Then use the HIERARCHY and HIERARCHYBELONGSTO LOAD prefixes to create tables that allow to use your hierarchy in a list box tree view as well as dimensions in a pivot table.