You can select a data storage method to determine how and when Essbase stores 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 to discard the value.
To select a member data storage method:
Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.
Store Data—Stores the data value with the member. This is the default.
Dynamic Calc and Store—Calculates the data value when a user requests it and then stores the data value.
Dynamic Calc—Calculates the data value when a user requests it and then discards the data value.
Never Share—Does not allow members to be shared.
Label Only—Creates a member that is used for navigation. A label-only member contains no data value.
Note:
If you are using an aggregate storage outline, note the guidelines for selecting the Label Only option. See Aggregate Storage with Label Only Option.
Existing—Use the existing storage method.
External source—In the drop-down list, select the column in the database that contains the storage method.
Note:
For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide.
Note:
To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.