Creating a parent hierarchy

You must ensure that you are logged on to Infor Query & Analysis Cloud in Microsoft Excel and that you have permissions to the Q&A DataLink Server.

  1. Select Utilities > Hierarchy Designer to open the Hierarchy Designer window.
  2. Click the Product browse button and select Query & Analysis Cloud.
  3. Specify a name in the Hierarchy field.
  4. Click the Table browse button and select the table you require.
  5. Click the Item browse button and select the item you require.
  6. In the Mapping pane, click Add and select the mapping you require.
    The Hierarchy is displayed in the bottom-left pane.
  7. Select the Hierarchy then select the required range in the bottom-right pane.
  8. Click Save.