MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1071

Figure A-20: DrillUpMember ().

Note that only descendants that are immediately after the ancestor mem-
ber in set2 are stripped away. If an ancestor member specified in set2 is
not present in set1 , any descendants will remain. Descendants that pre-
cede the ancestor or that appear after another member that is not a des-
cendant has intervened will not be stripped away. A set returned by
DrillDownMember () or DrillDownLevel () will be suitable for drilling up
cleanly with this function. Figure A-20 illustrates the behavior of
DrillUpMember ().

See also: DrillDownMember ()

E

Error ( [ string_expr ] ) Returns: (no return) Extension: AS2005

The Error () function raises an error. This will propagate to callers; if an error
occurs for evaluating a cell that is an input to a function like Filter () or Order
() in an axis or slicer, the query will not successfully execute. If the error oc-
curs while calculating a result cell, then the client will receive an error result
when retrieving that cell's value. It may be possible to detect and work around
the error with the IsError () function that is part of VBA and .Net, although this
may not work correctly until service pack 1 of AS 2005.

Except ( set1 , set2 [, ALL]) Returns: set Standard

set1 - set2 Returns: set Extension: AS2005, AS2000