In SAP HANA Calculation Views, when creating a parent-child hierarchy, you must define how to handle orphan nodes (nodes whose specified parent does not exist in the dataset). The system provides several options for this scenario. Two of these options are to treat each orphan node as a new root node, effectively creating a hierarchy with multiple roots (a forest), or to assign all orphan nodes as direct children of a single, specified, existing root node (e.g., an 'Unassigned' category).

A. The parent for an orphan node is assigned based on predefined rules (e.g., making it a root or assigning to a specific node), not by a dynamic expression.

B. Assigning orphan nodes to a leaf node is structurally invalid, as a leaf node, by definition, cannot have children.

1. SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Business Application Studio

Section: "Create Parent-Child Hierarchies".

This guide details the properties of parent-child hierarchies. For the "Orphan Nodes" property

it explicitly lists the options: Error

Ignore

Root Nodes

and Assign to Root Node. This directly supports options D ("Define them as additional root nodes" which corresponds to Root Nodes) and C ("Assign them to an existing node at the root level" which corresponds to Assign to Root Node).

2. SAP HANA Platform 2.0 SPS 07

SAP HANA Modeling Guide

Chapter: "Creating Hierarchies"

Section: "Create Parent-Child Hierarchies".

Page/Section Reference: In the "Properties of Parent-Child Hierarchies" subsection

the handling of "Orphan Nodes" is described. The available settings confirm that orphans can be treated as Root Nodes or assigned to a specific Root Node

validating answers C and D. The guide does not mention assignment via expression or to a leaf node.