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

Step 2. Add Levels to the Dimension

Step 2. Add Levels to the Dimension

After you create the dimension, add the needed levels. Levels hold the properties necessary to create target tables.
To add a level to a dimension:
  1. In the Dimension Editor, select Levels and click Add Level.
  2. Enter a name and description for the level.
    The Level name must be unique within the dimension.
  3. Click Level Properties.
  4. Click the Import from Source Fields button.
    The name of a level property must be unique within the dimension.
  5. Select a source table from which you want to copy columns to the level.
    The columns display in the Source Fields section.
  6. Select the columns you want to add to the level.
  7. Click the Copy Columns button to add source columns to the level.
  8. Click the Add Columns button to add a new column to the level.
  9. Click OK after you add all the columns.
    The Dimension Editor displays the new level.


Updated June 25, 2018