MULTIPLICATION (*)

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

  • Node1: First factor node, specified using the node name in single quotes (e.g. 'Volume')
  • Node2: Second factor node, specified using the node name in single quotes (e.g. 'Price')

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

Was this helpful?

Yes | Somewhat | No