Calculation of Shared Members

A calculation on a shared member in Essbase is a calculation on its prototype member.

If you use the FIX command to calculate a subset of a database and the subset includes a shared member, Essbase calculates the prototype member.

Shared members are those that share data values with other members. For example, in the Sample Basic cube, Diet Cola, Diet Root Beer, and Diet Cream are consolidated ("rolled up") under two parents: under Diet and under their product types—Colas (which is the alias for 100), Root Beer (the alias for 200), and Cream Soda (the alias for 300). The members under the Diet parent are shared members. See Shared Members.

Figure 19-10 Shared Members in Product Dimension


Product dimension of Sample Basic is expanded to reveal stored level 2 members and shared level 1 members.