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.

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)

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)