Value Was Originally Created As a Children And Needs To Be Removed From All Values And Make It a Parent (Doc ID 2310970.1)

Last updated on NOVEMBER 04, 2019

Applies to:

Symptoms

On : 11.1.11.1.0 version, Financial Reporting and Analysis

ACTUAL BEHAVIOR
---------------
Changed a value D98 - CC Loss Prevention in its value set from child to parent, since it was setup improperly. There are several hierarchies using the value set, but just 2 new hierarchies will use the value D98 and its children ( DEPT - Corporate Center - Version0 and Version1), but these 2 hierarchies have never been published, even though the publishing process ends successfully.


EXPECTED BEHAVIOR
-----------------------
The hierarchies should be published and modified value should be displayed from Smart View, Inquires and Reports as a Parent Value.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create the value incorrectly as a child.
2. The value is added to All Values.
3. Change the value as a Parent and modify the non published hierarchies accordingly.
4. Try to Publish the Hierarchies, the process ends successfully but the hierarchies are not published.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users are not able to see the hierarchies that use the modified value as parent, impeding its use on Inquires and Reports.

Additional Facts:

The steps normally followed to apply changes in the hierarchies listed below, did not fix the issue. The explanation is that the system never deletes a value from All Values, unless the cube is rebuilt.
1. Make the value a child (which was the original incorrect setting).
2. Unpublish all published hierarchies.
3. Make the value a child in all non published hierarchies.
4. Publish the hierarchies back.
5. Un publish the hierarchies.
6. Make the value a parent.
7. Make the value a parent in all non published hierarchies.
8. Publish the hierarchies back.
9. The publish process ends successfully, but no hierarchies are published.

Cause

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