MULTIPLICATION (*)
Basic Overview
Description | Multiplies nodes by performing a a join along the shared levels of the nodes (dimension union). The result has all the finest levels that are present in either of the nodes. |
Signature | Node1 * Node2 |
Parameters |
|
Examples
Example with all Shared Dimensions
Node1 =
| Year | Measure |
|---|---|
| 2018 | 2 |
| 2019 | 4 |
Node2 =
| Year | Measure |
|---|---|
| 2018 | 3 |
| 2019 | 1 |
Node1 * Node2 =
| Year | Measure |
|---|---|
| 2018 | 2 * 3 = 6 |
| 2019 | 4 * 1 = 4 |
Example with some Shared Dimensions
Node1 =
| Year | Measure |
|---|---|
| 2018 | 2 |
| 2019 | 4 |
Node2 =
| Year | Product | Measure |
|---|---|---|
| 2018 | A | 2 |
| 2018 | B | 0 |
| 2019 | A | 1 |
| 2019 | B | 4 |
Node1 * Node2 =
| Year | Product | Measure |
|---|---|---|
| 2018 | A | 2 * 2 = 4 |
| 2018 | B | 2 * 0 = 0 |
| 2019 | A | 4 * 1 = 4 |
| 2019 | B | 4 * 4 = 16 |
Example without Shared Dimensions
Node1 =
| Year | Measure |
|---|---|
| 2018 | 2 |
| 2019 | 4 |
Node2 =
| Measure |
|---|
| 2 |
Node1 * Node2 =
| Year | Measure |
|---|---|
| 2018 | 2 * 2 = 4 |
| 2019 | 4 * 2 = 8 |