age dimension and age level
The All level is a special, optional level
, which appears in all the hierarchies of a dimension
. If defined, this level contains one member
, the All member, which corresponds to all records in the cube. You can use the All member to create a summary line in a pivot table.
Examine a row of a pivot table and see the data for that row displayed in a more granular way. For example, a row might display data for a year, and you would drill down to see data for that year, broken out by month. Business Intelligence supports multiple forms of drill down. See “Performing Ad Hoc Analysis
” in Using the Analyzer
Informally (although not in this documentation), the phrases drill down and drill through
are sometimes used interchangeably, and it is wise to double-check which phrase is intended.
In casual usage, a higher level is called the parent of the lower level. However, it is useful to remember that the hierarchy is a actually a hierarchy among members. Thus it is more accurate to state that a member of the higher level is the parent of one or more members of the lower level. Conversely, any member of a lower level is the child of exactly one member of the higher level.
source class, source records
time dimension and time level