My Oracle Support Banner

When Running Aggregation Receive "ERROR: (XS01) One Or More Loops Have Been Detected In Hierarchy" (Doc ID 456285.1)

Last updated on MARCH 10, 2020

Applies to:

Oracle OLAP - Version 10.1.0.2 and later
Information in this document applies to any platform.
All OLAP client tools.


Symptoms

When running aggregation receiving following error message:

ERROR: (XS01) One or more loops have been detected
in your hierarchy n over N. The loops include 2 items
(UNDIRECTED: X and Y).

In the preceding error message, X is the name of the detail data cell, and Y is the name of the ancestor cell into which the detail data cell takes more than one path to aggregate.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.