Business Intelligence Tutorial

Setting member properties

In this exercise you will change a property for a dimension member.

  1. Notice how the properties of the member are displayed to the right of the member name. The fields in white are properties of the dimension that you can change:

    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.

    Consolidation
    This property determines how child values are rolled up to parents. The default is a plus sign (+), which means the child values are added to the parent value.

    Alias
    You can assign an alias name to the dimension.

    UDA
    You can create a user-defined attribute (UDA) for the dimension.
  2. On the Set Member Properties page, you can change some of the properties for individual members that you previously set for the entire dimension, plus one that is unique to members. Under the Dimension heading, click the Accounts dimension. Notice that the members are displayed in the Member List field.
  3. Under the Data Storage heading, click the value in the Consolidation column for the MISC member. A list box button opens in the cell. Change the property to a minus sign (-).
    Set Member Properties page
    Now, when the values in the Misc member are rolled up into the Accounts dimension, the Misc values will be subtracted, not added.
  4. Click Next and the Set Accounts Properties page is displayed.


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