Business Intelligence Tutorial

Editing dimension tables

In this exercise, you will hide a column in the Product dimension so that it does not appear in the model:

  1. In the Dimension List field, select the Product dimension.
  2. Look for CAFFEINATED in the Column Detail field. Under the Hidden heading next to CAFFEINATED, click the check box. The window looks like this:
    Edit Tables page

    You could also give the columns more descriptive names without having to change the column names in the source data. These names are called Essbase generation names and they identify the columns in the final OLAP application. If you do not assign Essbase generation names, they default to the columns names. Do not assign generation names at this time.

  3. Click Next and the Define Hierarchies page is displayed.


[ Top of Page | Previous Page | Next Page | Table of Contents ]