Essbase - Consolidation Storage Properties

Essbase Overview


Data storage properties define where and when consolidations are stored.

For example, by default, members are tagged as store data. Essbase sums the values of store data members and stores the result at the parent level.

You can change the default logic for each member by changing the data storage property tag for the member. For example, you can change a store data member to a label only member. Members with the label only tag, for example, do not have data associated with them.


Data Storage Properties Effects on Members
Store data The member stores data. Store data is the default storage property.
Dynamic Calculation The data associated with the member is not calculated until requested by a user. The calculated data is not stored; it is discarded after the request is completed.
Dynamic Calc and Store The data associated with the member is not calculated until it is requested by a user. The calculated data is then stored.
Shared member The data associated with the member comes from another member with the same name.
Never share The data associated with the member is duplicated with the parent and its child if an implied shared relationship exists.
Label only Although a label only member has no data associated with it, it can display a value. The label only tag groups members and eases navigation and reporting. Typically, label only members are not calculated.

For example, in the Measures dimension, the member Ratios has three children, Margin%, Profit%, and Profit per Ounce. The member Ratios defines a category of members. When consolidated, Margin%, Profit%, and Profit per Ounce do not roll up to a meaningful figure for Ratios. Hence, Ratios is tagged as label only.

Discover More
Essbase Overview
Essbase - ASO/BSO Storage

Essbase support two storage type : block storage (BSO) and aggregate storage (ASO) as a persistence mechanism for multidimensional databases. How the data are internally stored is determined by...
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Outline For Optimized Query Times
Essbase - Designing an Outline to Optimize Query or Calculations Performance

The relative locations of dimensions in an outline can affect performance times : either or retrieval . Indeed, although they contain the same dimensions, the outline examples below : for Optimized...
Essbase Overview
Essbase - Members

Members are the individual components of a dimension. For example: the members of a Region dimension can be East, West, South, and Total US. Product A, Product B, and Product C might be members...

Share this page:
Follow us:
Task Runner