Business Intelligence Tutorial
In this exercise you will change a property for a dimension
member.
- 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.
- 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.
- 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
(-).

Now, when the values in the Misc member are rolled up into the Accounts
dimension, the Misc values will be subtracted, not added.
- Click Next and the Set Accounts Properties page is
displayed.
[ Top of Page | Previous Page | Next Page | Table of Contents ]