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
HOWTO
Web Reporting
Web App Integration
Installation
Local Settings
Displaying a Report
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
MDX OO Extensions
JAVA Integration
R Integration
Reference
icCube Client Library
XMLA Client Library
Subset (standard MDX)

Returns subset of the original set in the specified range of elements.

Parameters

Name Type Cardinality Default value
  set-expression     
start-index  numeric-expression  one   
count  numeric-expression  zero-one  infinite 

Return

set

Description

Returns a set containing 'count' number of the elements beginning at start-index.

If the count parameter is not specified the subset starting from a specified index and going to the end of the specified set is returned.

If the count parameter is lower or equals to 0, an empty set will be returned.

Examples

Subset(member-set,start,count)
Subset(member-set,start) - no count
Subset(member-set,start,count) - specified elements count > than size of the set
Subset(member-set,start,count) - negative count

Special Examples (errors, null, ...)

Subset({},numeric),Subset(NULL,numeric)
Subset(member-set,numeric,string)
Subset(member-set, string)
Subset(string,numeric)

XMLA Properties

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

icCube OLAP version: 3.0.3 03-Mar-2013 14:06:07 GMT