Sunday, October 21, 2007

query designer: Temporal Joins for Hierarchies


The temporal join of time-dependent hierarchies allows you to view the leaves within a hierarchy under two (or more) nodes, depending on the validity period (attribute of the characteristic value).
To use this function you have to select the indicator for the "Use temporal hierarchy join" option. You make this setting in InfoObject maintenance on the "Hierarchy" tab page.
The following graphic provides an example of a temporal join for a hierarchy. The product "Monitor flat 17CN" is assigned to node "all monitors" until 02.2005. From 02.2005 the "Monitor flat 17CN" is assigned to "17" Monitors". Using the temporal joins for hierarchies function, you can display the same leaf under multiple nodes.

No comments: