{"id":4595,"date":"2025-01-03T16:56:12","date_gmt":"2025-01-03T16:56:12","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4595"},"modified":"2026-01-16T15:39:44","modified_gmt":"2026-01-16T15:39:44","slug":"referencing-values-using-hierarchies-in-ibm-planning-analytics","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/referencing-values-using-hierarchies-in-ibm-planning-analytics\/","title":{"rendered":"How Do I Reference Values Using Hierarchies in IBM Planning Analytics?"},"content":{"rendered":"

Referencing Values Using Hierarchies in IBM Planning Analytics\"\"<\/strong><\/p>\n

IBM Planning Analytics enables developers to create sophisticated models by utilizing cell references in TurboIntegrator (TI) processes and rules. With the introduction of hierarchies in dimensions, developers can now leverage these references to perform targeted updates, calculations, and validations at various levels within a hierarchy. This article explains how to use cell references with hierarchies effectively and provides examples of their practical applications.<\/p>\n

Understanding Hierarchy-Aware Cell References<\/strong><\/p>\n

Hierarchies add a layer of flexibility to dimensions, allowing for alternate groupings or roll-ups of elements within the same dimension. In Planning Analytics, cell references can explicitly reference a specific hierarchy in a dimension using the following syntax, comparing to the standard element reference:<\/p>\n

Process Syntax:<\/strong><\/p>\n

Standard:\u00a0\u00a0 \u00a0CellGetN( CubeName, Element1<\/strong> , Element2 ) ;<\/p>\n

Hierarchy:\u00a0 \u00a0CellGetN( CubeName, Hierarchy1:Element1<\/strong> , Element2 ) ;<\/p>\n

Example:\u00a0\u00a0\u00a0\u00a0 Value = CellGetN( \u2018Sales\u2019 , \u2018Division\u2019:\u2019East\u2019<\/strong> , \u2018Total Products\u2019 ) ;<\/p>\n

Rule Syntax:<\/strong><\/p>\n

Standard:\u00a0\u00a0 DB( CubeName, !Dimension1<\/strong> , !Diimension2 ) ;<\/p>\n

Hierarchy:\u00a0 DB( CubeName, Hierarchy1:!Dimension1<\/strong> , !Diimension2 ) ;<\/p>\n

Example:\u00a0\u00a0\u00a0\u00a0 [\u2018East Sales\u2019] = DB( \u2018Sales\u2019 , \u2018Division\u2019:\u2019East\u2019<\/strong> , \u2018Total Products\u2019 ) ;<\/p>\n

The syntax examples above use the CellGetN and DB function for Processes and rules respectively, but other functions support the hierarchy reference syntax as well. In addition, there are hierarchy specific functions that take a hierarchy as one of the arguments. An example being the ElementIsAncestor function has the same purpose as the ELISANC function, but includes an argument for the Hierarchy. For more functions that can be used with hierarchies, check out IBM\u2019s official Planning Analytics documentation<\/a>.<\/p>\n

Practical Applications of Hierarchy-Aware Cell References<\/strong><\/p>\n