Closure

Closure

Description

The Closure transform allows you to generate a Reflexive Transitive Closure Table for the Mondrian OLAP engine. For more information on how a closure table can help Mondrian gain performance, go here Technically, this transform reads all input rows in memory and calculates all possible parent-child relationships. It attaches the distance (in levels) from parent to child.

Hop Engine	✓
Spark	?
Flink	?
Dataflow	?

Options

Option	Description
Transform name	The name that uniquely identifies the transform.
Parent ID field	The field name that contains the parent ID of the parent-child relationship.
Child ID field	The field name that contains the child ID of the parent-child relationship.
Distance field name	The name of the distance field that will be added to the output
Root is zero	Check this box if the root of the parent-child tree is not empty (null) but zero (0)