Essbase - Shared Members

Essbase Overview


The data values associated with a shared member come from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once. To define a member as shared, an actual non-shared member of the same name must exist.

For example, in the Sample.Basic database, the 100-20 member under 100 stores the data for that member. The 100-20 member under Diet points to that value.

Shared members typically are used to calculate the same member across multiple parents; for example, to calculate a Diet Cola member in both the 100 and Diet parents.

Using shared members lets you use members repeatedly throughout a dimension. Essbase stores the data value only once, but it displays in multiple locations. Storing the data value only once saves space and improves processing efficiency.

Shared members must be in the same dimension. Data can be shared by multiple members.

Members with the same name may be duplicate members instead of shared members.


Would shared members be more efficient if designed within an Essbase - Attribute dimensions (other than shared)?

Discover More
Essbase Overview
Essbase - (Parent-Child|Dimension Reference) Build Method

A parent-child reference build method is aimed to : Create shared members that roll up into different generations Share non-level 0 members Modify properties of existing dimensions and members ...
Essbase Overview
Essbase - Build Method

The build method has to be choose to perform a dimension build. The build method that you select : depends on the type of data in the data source and determines the algorithm that Essbase uses...
Tbc Product Dimension
Essbase - Consolidation Operator

The consolidations operator define the consolidation path and can be used in formulas. It defines how Essbase rolls up data for each member in a branch to the parent. Operator Representation Description...
Essbase Overview
Essbase - Consolidation Path

The definition of the consolidation operator define the consolidation path. The TBC application has several consolidation paths: Individual products roll up to product families, and product families...
Essbase Overview
Essbase - Consolidation Storage Properties

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...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...
Essbase Overview
Essbase - Level Reference Build Method

level reference is a build method that you must specify during a dimension build. It's aimed to : Create shared members that roll up into different generations Modify the properties of existing dimensions...
Essbase Overview
Essbase - Outline Creation and Management using Outline Editor

This article provides an overview of creating outline using Outline Editor. For information Outline Editor, see the Oracle Essbase Administration Services Online Help. All examples in this chapter are...
Essbase Outline Repetition Scenario
Essbase - Suppression of repetitions in Outline by adding a dimension

The repetition of elements in an outline often indicates a need to split dimension. The following examples show you how to avoid repetition. In the figure below, the left column, labeled “Repetition”,...
Essbase Short Cycle
Essbase - The OLAP Design Cycle (to create an optimized database)

A contains two types of values : the values that you enter or load (input data) and the values that are calculated from the input data (calculated data) Then a typical conforms to the following...

Share this page:
Follow us:
Task Runner