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
FirstNotAllLevel (icCube MDX extension)

Returns the first not all level of a hierarchy

Parameters

Name Type Cardinality Default value
  hierarchy  one   

Return

level

Description

Returns the first level of the hierarchy excluding the all level.

See Also

LastLevel

Examples

FirstNotAllLevel(hierarchy)

Special Examples (errors, null, ...)

FirstNotAllLevel(NULL)

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