Databases Reference
In-Depth Information
INDIANA
moves to
WEST
along with its profit, but the
EAST
still shows 5
million dollars, and
WEST
still shows 8 million dollars. In order to show the
right numbers, the data needs to be recalculated as the parents WEST and
EAST are stored data. In our example, we will enable this property for the
Total Market
member.
° Allow property changes: This allows the rules file to update
the data storage properties, and consolidation operators.
For example, changing the
Dynamic Calc
setting to
Dynamic
Calc and Store
, or from (+) to (-) consolidation on a member.
If this option is disabled, the rules will not allow the member
properties to be updated. In our example, we will enable the
Allow property changes
. And yes, in your data file, the column
that you designate as the member properties will actually contain
the characters used in the database outline editor to indicate the
specific properties. For example, if the member you are adding
will have a consolidation of add, there will be a plus character (
+)
in the data. When this column is tagged as the member properties
column during the build, Essbase will set the consolidation
property to
+
.
°
Allow formula changes:
This allows the rule file to update
the formula on a member, if a formula exists. If this property
is disabled, you will not be allowed to change the formula from
the rules file. In our example, we do not have a new property
for
Total Market
so we are not enabling this property.
•
Select the Build method
: This is where you specify which method is used
by this rules file to update the outline. There are three main methods in
this section from which you can choose. We have previously chosen the
Generation method as our source file is in the top to bottom hierarchical order.
•
Member sorting
: This property will set the sorting order while updating
the outline using this rule. This sorting is applied to all of the members
under this dimension.
These are the three sorting choices you can make:
°
None
: No sorting order is selected
°
Ascending
: Updates the outline in the ascending sort order
°
Descending
: Updates the outline in the descending sort order
For our example, let's select the
Ascending
order (A to Z).
