Moving members in an Oracle Analytic Cloud Essbase outline is not as easy as it is in EAS Console. Here’s an overview of a not-so-genius method I found.
Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.
Scenario: An account moves to a different parent. There is no move method in the OACS outline editor and if the account is shared elsewhere, we cannot just delete and re-add the member. Also moving requires that the prototype and the shared members be deleted, the outline saved, then the members added in the new location. This will obviously kill any data associated with the original member.
Assumption: The prototype member will always precede the shared member in the outline.
- Create a new load rule that allows moves for the dimension. The default is “Not OK” so this must be changed.
- Create a text file with ONLY the member(s) that are moving with the new parent.
- Upload the text file to the OACS instance.
- Create and run a build dimension job that uses the rule created in step one and the text file uploaded in step three.