Home > OLAP Calculation Templates > Simple Math > Addition
![]() Previous |
![]() Next |
Adds the values of one measure to the values of another measure.
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.
Add measure UNITS(CHANNEL=Internet, CUSTOMER=Europe) to measure UNITS(CHANNEL=Internet, CUSTOMER=AUSTRALIA)
UNITS_CUBE.UNITS[CUSTOMER = 'EMEA', CHANNEL = 'INT'] + UNITS_CUBE.UNITS[CUSTOMER = 'AUS', CHANNEL = 'INT']
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