Business Intelligence Tutorial
- On the Set Dimensions Properties page, notice how the properties of the
dimension are displayed to the right of the dimension name.

The fields in white are properties of the dimension that you can
change. These properties affect all the members of a dimension.
- Storage
- Dimensions can be either Dense or Sparse. A Dense dimension is
likely to contain data for every combination of dimension members, for
example, the Time dimension. A Sparse dimension has a low probability
that data exists for every combination of dimension members, for example, the
Product or Market dimensions.
- Data Storage
- This property determines how and when data values are stored for a
member. For example, you can store the value (the default), dynamically
calculate and store the value, indicate that a member is shared between
dimensions, and so on.
- Two Pass Calc
- Calculations are performed from the bottom up, from child values to parent
values. The values of some child members might depend on parent values,
requiring two calculations.
- Alias
- You can assign an alias name to the dimension.
- UDAs
- You can create a user-defined attribute (UDA) for the dimension.
- Click Next and the Set Member Properties page is
displayed.
[ Top of Page | Previous Page | Next Page | Table of Contents ]