English
PowerCenter All Products

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Step 4. Add Levels to the Hierarchy

Step 4. Add Levels to the Hierarchy

After you create a hierarchy, you add levels to it. You can have only one root level in a hierarchy.
To add a level to a hierarchy:
  1. From the Dimension Editor, drill down to view the levels in the dimension.
  2. Drag the level you want to define as the root level in the hierarchy.
    The root level is the level of finest granularity.
  3. Enter a target table name and description of the target table.
  4. Click OK.
    A window displays a listing of all the objects affected by the new level.
  5. Click OK.
    The new level displays under the hierarchy.

Updated June 25, 2018

Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal