The Calculation Type page accepts input for the following items for a share calculation:
Share Of
A measure or calculated measure to be used in calculating the share. It must be dimensioned by the For dimension.
For
The dimension for which the share is to be calculated.
In
The hierarchy to be used while calculating the share for the selected dimension.
As a Percent of
The dimension member to be used as a baseline to calculate the share. Select one of the following choices:
Total. Specifies that the baseline consists of the total of all items on the level that is associated with the current member (that is, the item for which share is being calculated). This option is disabled for a dimension that has no hierarchies.
Parent. Specifies that the baseline consists of the total on the level of the parent for the current member (that is, the item for which share is being calculated). This option is disabled for a dimension that has no hierarchies.
Level. Specifies that the baseline consists of the total of a level to be specified. Choosing this item requires the selection of a value in the associated drop-down list. This list displays the names of levels from the selected hierarchy for the selected dimension that are available for calculating the share. This option is disabled for a dimension that has no hierarchies.
Member. Specifies that the baseline consists of the total for a dimension member to be specified. Choosing this item requires the selection of a value in the associated drop-down list. This list displays the names of the dimension members that are available for calculating the share.
The formula for this calculation is:
(Current Member/Specified Member)
This formula is used to return the ratio of a measure's vaue to the same measure value for another dimension member or level.
An example of this calculation is:
The share of 19" TV sales to Total TV Sales = (19" TV Sales/Total TV Sales)
Copyright © 2003, 2007, Oracle. All rights reserved.