An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library
Ascendants (standard MDX)

Returns all the ancestors of a specified member and the member itself.

Parameters

Name Type Cardinality Default value
  member-expression  one   

Return

set

Description

Returns all the ancestors of a specified member and the member itself up to the root of the member's hierarchy. Note that the specified member is returned first, then its parent, its grandparent and so on.

See Also

Ancestor Ancestors Descendants

Examples

Ascendants(member)

Special Examples (errors, null, ...)

Ascendants(NULL)
Ascendants(tuple)
Ascendants(level)
Ascendants(memberSet)
Ascendants(tupleSet)
Ascendants(string)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT