Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 18)

dimension and an accounts dimension. Other dimensions may categorize products, markets,

and scenarios. Using dimensional organization, you can define any consolidation structure or

any slice of data that is relevant to the application. Essbase supports an unlimited number of

dimensions.

Members

Members are the names of the elements within a dimension. A dimension can contain an

unlimited number of members. The calculation, reporting, and dimension-building features in

Essbase use the following terms to describe members.

● Parents. A parent is a member with a consolidation branch below it. Figure 5 shows an

example of Qtr1 as a parent member because below Qtr1 is a branch containing months as

members.

Figure 5 Relationships Among Database Members

● Children. A child is a member with a parent above it. For example, Jan, Feb, and Mar are

children of the parent Qtr1.

● Siblings. A sibling is a child member of the same parent and on the same branch (same level).

For example, Jan, Feb, and Mar are siblings. Apr is not a sibling of Jan, Feb, or Mar, however,

because it has a different parent, Qtr2.

● Descendants. A descendant is a member at any level below a parent. For example, each

member that falls in the Year branch is a descendant of Year. The following members are

all descendants of Year: Qtr1, Jan, Feb, Mar; Qtr2, Apr, May, Jun; Qtr3, Jul, Aug, Sep; Qtr4,

Oct, Nov, Dec.

● Ancestors. An ancestor is a member of a branch above a member. For example, Qtr2 and

Year are ancestors of Apr.

● Generations. The term generation describes the branch number of a member. Generations

count from the root of the tree (generation 1, which is the dimension name) toward the leaf

node.

● Levels. The term level describes the branch number of a member. Levels count from the leaf

node (level 0) toward the root (the dimension name).

Introduction to Essbase

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 18