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

Creating a Cube

Creating a Cube

To create a cube:
  1. From the Target Designer, click Targets > Create Cube.
  2. Enter the following information:
    • Cube name.
      The cube name must be unique in a folder.
    • Cube type.
      Choose Normalized or Non-normalized. Normalized dimensions must have a normalized cube. Similarly, non-normalized dimensions must have a non-normalized cube.
    • Database type.
      The database type for the cube must match the database type for the dimensions in the cube.
  3. Click Next.
  4. Specify the dimensions and hierarchies to include in the cube.
  5. Click Next.
  6. Add measures to the cube.
    You can copy columns from source tables or add new columns.
    Measure names must be unique within a fact. Level names must be unique within each cube.
  7. Add a name for the fact table.
  8. Click Finish.
    The Designer adds the cube and fact tables to the workspace.


Updated June 25, 2018