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

  • 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 = 

YearMeasure
20182
20194

Node2 = 

YearMeasure
20183
20191

Node1 * Node2 =

YearMeasure
20182 * 3 = 6
20194 * 1 = 4

Example with some Shared Dimensions

Node1 = 

YearMeasure
20182
20194

Node2 = 

YearProductMeasure
2018A2
2018B0
2019A1
2019B4

Node1 * Node2 = 

YearProductMeasure
2018A2 * 2 = 4
2018B2 * 0 = 0
2019A4 * 1 = 4
2019B4 * 4 = 16

Example without Shared Dimensions

Node1 = 

YearMeasure
20182
20194

Node2 = 

Measure
2

Node1 * Node2 =

YearMeasure
20182 * 2 = 4
20194 * 2 = 8