Custom2 members not aggregating and different errors encountered
Summary:
The issue originally surfaced after the GRO, GRI, and GRF hierarchies were moved from the now deleted parent member MFRS18_ACC to Total Custom2. Although data loads successfully to descendants, consolidation values are incorrect, causing significant reporting variances. Attempts to restore the original hierarchy failed due to errors related to virtual members.
Content (please ensure you mask any confidential information):
During troubleshooting, the team completely reloaded the data into another Custom2 member and removed the GRO, GRI, and GRF hierarchies, including all descendant members. Upon refreshing the database, the system returned the error: "Level 0 virtual member MFRS18_ACC must have a formula associated with it."
Tagged:
0