You can determine how and when Essbase stores data values for a dimension. For example, you can tell Essbase to calculate the value for a dimension only when a user requests it and then to discard the value.
To select the data storage method for a dimension:
Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension 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.
Note:
When the Dynamic Calc and Store setting or the Dynamic Calc setting is used with an aggregate storage outline, warnings may be generated during outline validation and data loads. These warnings are usually status messages and may be ignored unless your cube deployment is not successful.
Never Share—Does not allow members to be shared implicitly.
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, you should be aware of guidelines for selecting the Label Only option. See Aggregate Storage with Label Only Option.
Existing—Use the existing data storage method.
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.
Note: | When the Dynamic Calc and Store setting or the Dynamic Calc setting is used with an aggregate storage outline, warnings may be generated during outline validation and data loads. These warnings are usually status messages and may be ignored unless your cube deployment is not successful. |