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
Tail (standard MDX)

Returns the last specified number of elements in a set.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  numeric-expression  zero-one  1 

Return

set

Description

Returns a set containing the specified number of the elements from the end of the specified set.

If no numeric expression is specified the last element of the set will be returned.

If the specified number of elements is less than 1, an empty set will be returned.

See Also

Head

Examples

Tail(set,count)
Tail(set)

Special Examples (errors, null, ...)

Tail(member-set,0)
Tail(set,count) - numeric too large
Tail(set,count) - negative count
Tail({},numeric)

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