Skip to Content
Feb 21, 2022 at 08:24 PM

Hierarchy validation at the time of data load


Hi Experts, I've a Local Table (Dimension) with a Parent-Child Hierarchy. For that table, we upload data manually, from a CSV. We are using that table in a view and then in an Analytical Dataset that is exposed to a SAC story.

When the hierarchy data is wrong (ie. a node has multiple parents, or no parent), we never get an error when we load the data, but we get the error in SAC story.

The question is: Is it possible to activate a hierarchy validation at the time of data load in DWC?

Thanks in advance,