Solutions
BI OverviewBusiness Intelligence overview
What we offerwhat do we have to offer to our customers
BI users
Corporate Customers
Partners And Resellers
Product Developers
Products
icCube OLAP SuiteModern MDX / XMLA OLAP Solution
icCube Web Reporting
icCube OLAP Server
icCube MDX IDE
icCube OLAP Designer
Featured ContributionsCommunity Contributions
XMLA Client Library
icCube Viz. Library GWT Wrapper
GWT Pivot Table
Download
Purchase
Edition ComparisonOrdering our products is just a step away
Enterprise Edition
Community Edition
OEM / Embedded Edition
Featured Contributions
Consulting & SupportEnhancing your productivity
Support Subscriptions
Support
Quality AssuranceEverything related to quality
Product Roadmap
Bug Tracking System
ForumMeet the community and developers
DocumentationMDX and icCube documentation
icCube User Guide
MDX Gentle Introduction
MDX Reference
Company
Partners
Jobs
Contact usWe'd love to hear from you

An MDX Question?

OLAP Server User Guide

Configuring icCube

Overview

Accessing the Configuration

icCube.xml

Notifications

Environment Variables

Running icCube

icCube Windows Service

WEB-based User Interface

XMLA Service

Startup Sequence / Application Directories

Multiple instances on the same machine

Migrating icCube

Security

Creating Schemas/Cubes

Data Sources

Real-Time Data Sources

Dimensions

MultiLevel Dimension

MultiLevel Dimension Advanced

Parent/Child Dimension

Path Dimension

Ranged Dimension (Banded)

Many-to-Many Dimension

Statistical Dimension

Time Wizard Dimension

Facts

Facts Standard

Facts Aggregation Types

Facts Many-to-many

Facts Multiple Levels

Advanced

Schema Factories

Schema/Cube XML Definition

Mixed (File + Excel)

Database

Walkthrough

Walkthrough (Real-Time)

Working with icCube

Offline Schemas/Cubes

Commands

Reporting Tools Integration

Embedding icCube

Plugins/Extensions

HOWTO

Web Reporting

Visualization Library

Tutorials

Datasource & connection

Selecting schema and cube

Selecting hierarchies and members

Selecting hierarchies and members (JQuery UI)

Selecting hierarchies and members (ExtJS)

Selecting multiple members with a tree (Beta)

First MDX request

Query parameters

Action

Query Manager workflow & events

Pivot Table

Pivot Table - Drilldown

Pivot Table - Rendering (client)

Pivot Table - Rendering (server)

Pivot Table - Events

Pivot Table - Export To Excel

Google Visualization Charts Integration

amCharts Integration

Protovis Integration

flot Integration

Sencha (ExtJS) Integration

D3 Integration (bullet chart)

Demos

World statistics dashboard

amCharts based dashboard

Drilldown down & Google Visualization charts

Interactive MDX request building

MDX Documentation

MDX Tutorial (Gentle Introduction)

Dimensions, Hierarchies and Levels

Members, Tuples and Sets

Member Name

SELECT Statement

WHERE (aka. slicer) Clause

FROM as a Slicer

Navigating the Hierarchy

Common Calculations

Calculated Members

Named Sets

MDX Functions Reference

Avg

HSV

Iif

Lag

Max

Min

Mtd

Qtd

RGB

StripCalculatedMembers

Sum

Ytd

MDX Language Reference

Cell Properties

Where Set Clause Exists

MDX OO Extensions

Reference

icCube Client Library

XMLA Client Library

Ancestors

(standard MDX)

Returns the ancestor of a specified member at a specified level or distance as a set. Same as Ancestors.

Parameters

Name	Type	Cardinality	Default value
	member-expression	one
level/distance	level-numeric-expression	one

Return

set

Description

Despite the 's' in its name this function is equivalent to Ancestor.

Examples

Ancestors(member,level)

Returns the Ancestors of member at the specified level as a set.

In our example the [Country] of [Paris] which is [France] as a set.

Query

Ancestors( [Geography].[Geo].[Paris], [Geography].[Geo].[Country] )

Result

{ 
  [Geography].[Geo].[Country].[France]
}

Assertion : MDX Equals

{[Geography].[Geo].[France]}

Ancestors(member,numeric)

Returns the Ancestors at a given distance from the member as a set.

In our example the grandparent of [Paris] which is [Europe]

Query

Ancestors( [Geography].[Geo].[Paris], 2 )

Result

{ 
  [Geography].[Geo].[Continent].[Europe]
}

Assertion : MDX Equals

{[Geography].[Geo].[Paris].Parent.Parent}

Ancestors(member,numeric) - same level

Returns the member as a set if distance (numeric) is zero. Same behaviour if we use a level which is equal to the member's level.

Query

Ancestors( [Geography].[Geo].[Paris], 0 )

Result

{ 
  [Geography].[Geo].[City].[Paris]
}

Assertion : MDX Equals

Ancestors( [Geography].[Geo].[Paris], [Geography].[Geo].[City] )

Assertion : MDX Equals

[Geography].[Geo].[Paris]

Special Examples (errors, null, ...)

Ancestors(member,numeric/level) - no ancestors

Returns an empty set when the specified member exists and has no ancestor.

Query

Ancestors([Geography].[Geo].[France], 1024)

Result

{}

Assertion : MDX Equals

Ancestors([Geography].[Geo].[France], [Geography].[Geo].[City])

Ancestors(NULL,1)

Returns NULL if the member is a NULL entity.

Query

Ancestors(NULL, 1)

Result

NULL

Ancestors(member,numeric) - negative distance

Returns an error if a negative distance (numeric) is entered.

Query

Ancestors([Geography].[Geo].[Paris],-1)

Result


Error Code    : OLAP_INVALID_DISTANCE_VALUE
Error Message : invalid distance value : '-1'

Ancestors(member,level) - not matching hierarchies

Returns an error if level and member does not belong to the same hierarchy.

Query

Ancestors( [Geography].[Geo].[Paris], [Geography].[Economy].[Country] )

Result


Error Code    : OLAP_DIFFERENT_HIERARCHIES
Error Message : unexpected hierarchy (expected:'[Geography].[Geo]') (actual:'[Geography].[Economy]')

Ancestors(tuple)