Skip Headers
Previous
Previous
 
Next
Next

Addition

Adds the values of one measure to the values of another measure.

Template

Add measure measure (...) to measure measure (...)

Example

This calculated measure adds two discrete selections of the same measure instead of adding two different measures. It creates a two-dimensional calculated measure in the Price Cube from the four-dimensional Units measure in the Units Cube. The calculated measure is dimensioned by Product and Time. Channel is set to the value of Internet, and Customer is set to the sum of Europe and Australia.

Calculation

Add measure UNITS(CHANNEL=Internet, CUSTOMER=Europe) to measure UNITS(CHANNEL=Internet, CUSTOMER=AUSTRALIA)

OLAP Expression Syntax

UNITS_CUBE.UNITS[CUSTOMER = 'EMEA', CHANNEL = 'INT'] + UNITS_CUBE.UNITS[CUSTOMER = 'AUS', CHANNEL = 'INT']

Query Results

The Unit Slice column shows the number of Units sold in Europe and Australia over the Internet.

Product              Time       Unit Slice
-------------------- ---------- ----------
Sentinel Financial   Q1.06              44
Sentinel Financial   Q2.06              35
Sentinel Financial   Q3.06              35
Sentinel Financial   Q4.06              40
Sentinel Multimedia  Q1.06              20
Sentinel Multimedia  Q2.06              34
Sentinel Multimedia  Q3.06              34
Sentinel Multimedia  Q4.06              42
Sentinel Standard    Q1.06              51
Sentinel Standard    Q2.06              52
Sentinel Standard    Q3.06              52
Sentinel Standard    Q4.06              69