Mapping to a parent-child source table

  1. Select Dashboards > OLAP > Edit Database.
  2. Select the database to administer.
  3. Click the Dimensions node of the database structure.
  4. Click the Hierarchies icon of the dimension for which to create mappings.
  5. Click the Mappings icon of the hierarchy.
  6. Click New Mapping.
  7. Specify a name for the mapping.
  8. Optionally, add comments to the mapping.
  9. In the Data Connection field, select the data connection that connects the application to the staging database.
  10. Select Parent-Child Table as the source data type.
  11. Select the source table or view.
  12. Select the source relationship table or view.
  13. In the Element Name Column field, select the source column that identifies the name of the elements in the source.
    For example, a CurrencyName column in a currency table, or a ProductName table in a table of products.
    Note: Ensure that the Element Name Column and the Child Element Name column are the same. If the column is an ID, then map to one of the localized caption attributes to ensure that the elements names are assigned to the IDs in the hierarchy.
  14. Optionally, in the Element Type Column field, select a source column that identifies the type of elements in the source.
  15. Optionally, in the Element Order Column field, select the source column that identifies the order of the elements.
  16. In the Parent Element Name Column field, select the source column that identifies parent elements.
  17. In the Child Element Name Column field, select the source column that identifies child elements.
    Note: Ensure that the Element Name Column and the Child Element Name column are the same. If the column is an ID, then map to one of the localized caption attributes to ensure that the elements names are assigned to the IDs in the hierarchy.
  18. Optionally, in the Weight Column field, select the source column that identifies the weights of elements.
  19. Optionally, in the Child Element Order Column field, select the source column that identifies the order of the child elements.
  20. Optionally, map attributes to columns in the source table.