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 |