Understanding Oracle Essbase Properties

Oracle Essbase has the following valid property types:

  • Data storage

    Data storage enables Essbase to recognize what type of storage to allocate for the member. Valid values are 0 or blank (store data), 1 (never share), 2 (label only), 3 (shared member), 4 (dynamic calculation and store), and 5 (dynamic calculation, no store).

    PeopleSoft Cube Builder sets the default value as store data for all members in the first rollup and the non-detail nodes of all other rollups. Detail nodes in secondary rollups are set to shared members.

  • Expense item

    Expense item applies to account dimensions only. Essbase has certain built-in formulas that can take advantage of the knowledge that an item is an expense. To pass this knowledge on to Essbase, you should use this property. Valid values are Blank (set) and non-Blank (do not set).

  • Time balance

    Time balance affects how the parent time value is calculated. Valid values are 0, 1, 2, and 3, which correspond to none, first, last, and average, respectively.

  • Consolidation

    This property enables you to define the mathematical operator used for rolling up members. Most often, you expect that data is added (using the + operator) when rolled up. However, you might occasionally need to specify other operators, such as those listed in the following table.

    Valid Value


    + (plus sign)

    Add (default).

    – (minus sign)


    * (asterisk)


    / (forward slash)



    Do not consolidate.

    ~ (tilde)

    Do not consolidate.

    % (percent sign)

    Divide the total of previous member calculations by this member and multiply by 100.

Note: See the Oracle Essbase documentation for more information.