ADS file Load of Members That Already Exist in EPMA Application Library Causes Base Members to be Moved as Shared and Imported Members as Base. What is the Cause? (Doc ID 1922632.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

Goal

Problem: Removing shared members from dimension results in deleting data on members

Begin status: Application includes unique members in dimension Measure. Data are stored in several scenarios/versions

Action: New members were uploaded into dimension Measure (*.ads file using Import dimension fuctionality) – unfortunately some members were already included in dimension –> new duplicated members were stored as primary, the original members as shared.
Application deployed.

Action: Removing (or moving shared members to other place in the hiearchy) shared members (the primary members stay on their locations in dimension).
Application deployed.

Result: The data on member (where the shared member has been removed or moved) is missing (deleted).

Is there any way how to remove the shared members and concurrently preserve the date stored on primary members?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms