Determining How Members Store Data Values

You can determine how and when Essbase stores the data values for a member. For example, you can tell Essbase to calculate the value for a member only when a user requests it, and then discard the data value. Table 17 describes each storage property.

Table 17. Choosing Storage Properties

Storage Property

Behavior

See

Store

Stores the data value with the member.

Understanding Stored Members

Dynamic Calc and Store

Does not calculate the data value until a user requests it, and then stores the data value.

Understanding Dynamic Calculation Members

Dynamic Calc

Does not calculate the data value until a user requests it, and then discards the data value.

Understanding Dynamic Calculation Members

Never share

Does not allow members to be shared implicitly.

Members tagged as Never share can only be explicitly shared. To explicitly share a member, create the shared member with the same name and tag it as shared.

Understanding Implied Sharing

Label only

Creates members for navigation only; that is, members that contain no data values.

Understanding Label Only Members

Shared member

Shares values between members. For example, in the Sample.Basic database, the 100-20 member is stored under the 100 parent and shared under Diet parent.

Understanding Shared Members

  To set member storage properties, see “Setting Member Storage Properties” in the Oracle Essbase Administration Services Online Help.