DIVISION (/)
Basic Overview
Description | Divides nodes by performing 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 |
|
Example with all Shared Dimensions
Node1 =
| Year | Measure |
|---|---|
| 2018 | 6 |
| 2019 | 4 |
Node2 =
| Year | Measure |
|---|---|
| 2018 | 3 |
| 2019 | 1 |
Node1 / Node2 =
| Year | Measure |
|---|---|
| 2018 | 6 / 3 = 2 |
| 2019 | 4 / 1 = 4 |
Example with some Shared Dimensions
Node1 =
| Year | Product | Measure |
|---|---|---|
| 2018 | A | 4 |
| 2018 | B | 0 |
| 2019 | A | 4 |
| 2019 | B | 16 |
Node2 =
| Year | Measure |
|---|---|
| 2018 | 2 |
| 2019 | 4 |
Node1 / Node2 =
| Year | Product | Measure |
|---|---|---|
| 2018 | A | 4 / 2 = 2 |
| 2018 | B | 0 / 4 = 0 |
| 2019 | A | 4 / 4 = 1 |
| 2019 | B | 16 / 4 = 4 |
Example without Shared Dimensions
Node1 =
| Year | Measure |
|---|---|
| 2018 | 4 |
| 2019 | 8 |
Node2 =
| Measure |
|---|
| 2 |
Node1 / Node2 =
| Year | Measure |
|---|---|
| 2018 | 4 / 2 = 2 |
| 2019 | 8 / 2 = 4 |