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. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Tips for Cubes and Dimensions

Tips for Cubes and Dimensions

Consider the following tips when working with cubes and dimensions:
  • If you want to copy a cube, you need to copy the folder that stores the cube.
  • To view the levels of a cube or dimension, you can either edit the cube or dimension or use the Navigator in the Repository Manager.
  • You cannot revert to previous versions of cubes or dimensions.
  • You can delete a cube or dimension from the Navigator.
  • You can delete a dimension using Targets > Create/Edit Dimension.
  • You cannot delete cubes and dimensions from the Target Designer workspace.
  • If you want to change a column in a fact table or dimension table, you need to edit the cube or dimension. You cannot edit a fact table or dimension table directly.
  • If you delete a level, the Designer deletes the associated level instances in hierarchies. The Designer also removes the level instance from any associated cubes.
  • A primary key is generated for each fact and dimension table. The format is GK_
    TABLE_NAME
    .
  • A foreign key is added to the appropriate fact table when you associate a dimension level instance to the fact table.
  • You can drag a cube to the workspace and then edit the cube and cardinality by double-clicking the links.
  • You cannot delete or create a link between fact and dimension tables in the workspace. You can only delete and create links in the Cube and Dimension Editors. You can create a graph in the hierarchy.

0 COMMENTS

We’d like to hear from you!