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

Returns the sum value of the specified set expression.

Parameters

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

Return

value

Description

Returns the sum value of the specified set, evaluated using 'value-expression'.

If no numeric expression is specified, the current members context will be used to evaluate the tuples.

Examples

Sum(tuple-set, Numeric_Expression)
Sum(tuple-set)

Special Examples (errors, null, ...)

Sum(NULL),Sum({})

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