Databases Reference
In-Depth Information
Standard
Like DrillDownMember (), this function returns a set that is formed by
drilling down one level on each member in
set1
that is present in
set2.
However, it returns the top
index
children for a parent rather than all chil-
dren.
Set1
can be of arbitrary dimensionality;
set2
must be of only one di-
mension.
If
set1
contains tuples, this will return a set formed by drilling down each
tuple in
set1
that has a matching member from
set2
in it. If RECURSIVE
is not specified, then only one pass through
set1
is performed, matching
each member or tuple with each member in
set2.
If RECURSIVE is spe-
cified, then the set that results from the first pass is again matched with
each member in
set2
, and so on until no more members in the set being
constructed are found in
set2.
At each step of drilling, the top
index
child
members or tuples are returned instead of all children. The ranking is
based on the
numeric expression
, if specified; otherwise, values from the
set of children are evaluated in the current context, and those results are
used.
Figure A-18
illustrates the behavior of DrillDownMemberTop ().
Figure A-18:
DrillDownMemberTop ().
DrillUpLevel (
set
[,
level
])
Returns: set Standard
This function strips away all members in the set that are below the
given
level.
(In Essbase, either a generation or level may be used.) If
Search WWH ::
Custom Search