DIVISION (/)
DIVISION (/)
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 