The easiest way to determine the columns of an imported Hierarchy file is to export the Hierarchy as shown above. The exported file can then be modified and reimported to update the Hierarchy. This is useful if there are a large number of changes that need to be made.
To import a Hierarchy:
Open the Feature bar, open the Model folder, and select Hierarchy.
The Hierarchy tab will open. Select the Hierarchy that you want to import into and select the Import option under the Utilities drop-down menu.
Check the Import options to make sure the import will function as you desire. Click the Next button.
Add or remove levels, if required.
Click the Next button.
Click the Browse button and navigate to the input file.
Click the Open button.