Placing Actual Members Before Shared Members

For aggregate storage outlines, Essbase requires that actual members are always placed before shared members. When building your Essbase model, you may have placed shared members before actual members in recursive dimensions.

By selecting a check box in the Outline Build tab of Essbase Model Properties, all instances of shared members before actual members are reversed.

  If the Essbase model contains shared members placed before actual members, select this check box:

Reverse position of shared and actual members if shared member is located before actual member

Below are examples showing the recursive hierarchy members before and after Essbase fixes the shared member and actual member order. Note that the order of the parents remains the same; the position of the actual member changes.

Case 1, Before

Employees (dimension)
    Engineer
        John Smith (shared)
    Manager
        John Smith (shared)
    Director
        John Smith (actual)

Case 1, After

Employees (dimension)
    Engineer
        John Smith (actual)
    Manager
        John Smith (shared)
    Director
        John Smith (shared)

Case 2, Before

Employees (dimension)
    Engineer
        John Smith (shared)
        Paul Williams (shared)
    Manager
        John Smith (actual)
        Paul Williams (actual)

Case 2, After

Employees (dimension)
    Engineer
        John Smith (actual)
        Paul Williams (actual)
    Manager
        John Smith (shared)
        Paul Williams (shared)