Using Calculation Segmentation

A rule’s source range is the combination of all member selections at level 0. For very large models, source ranges can exceed the Essbase limits on query ranges. In those cases, the rule fails unless segmentation is used to break the rule into smaller pieces that can fit within the Essbase limitation.

Profitability and Cost Management Cloud performs segmentation by taking one dimension’s member selections and creating a separate script for each member at a lower level of that dimension. For example, if a member has ten immediate children, the segmentation method would create a separate script for each of the ten children. The results of the calculation are the same.

To use this feature, generally when recommended by Oracle, see instructions for defining an allocation rule source.