SAP Knowledge Base Article - Preview

3636962 - SAC Import Fails When Using <root> as Hierarchy Parent – Snowflake to Public Dimension

Symptom

  • When attempting to import data from Snowflake into a public dimension model in SAP Analytics Cloud, rows are rejected if a literal <root> value is used in the hierarchy parent column.
  • Users experience import errors, even if <root> appears only once. The intended purpose of the hierarchy is to support selective locking/unlocking of specific dimension members via multi actions.


Read more...

Environment

SAP Analytics Cloud 2025.8.13 

 

Product

SAP Analytics Cloud 1.0

Keywords

SAC, hierarchy, parent-child, root node, import error, data rejected, multi actions, Snowflake, locking, top node , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.