Business Intelligence Tutorial

Setting dimension properties

  1. On the Set Dimensions Properties page, notice how the properties of the dimension are displayed to the right of the dimension name.
    Set Dimensions Properties page
    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.
  2. Click Next and the Set Member Properties page is displayed.


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