Moving a Member in an OACS Essbase Outline

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.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

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.

1. Create a new load rule that allows moves for the dimension. The default is “Not OK” so this must be changed.
2. Create a text file with ONLY the member(s) that are moving with the new parent.
3. Upload the text file to the OACS instance.
4. Create and run a build dimension job that uses the rule created in step one and the text file uploaded in step three.