You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Metadata load to Essbase ASO having Allow Duplicate Members option enabled

Received Response
9
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

ODI unable to load the metadata to another dimension having same member / alias names which other dimension have in ASO cube

Content

- I am loading metadata to an ASO cube (ESS_REP) for which I have enabled allow duplicate members option.

- The source of loading metadata is another ASO cube (CRAv1R)

- I created ODI Interface which is working fine to load the dimension S1Accounts but is failing to load members to another dimensions S2Accounts / S3Accounts. After analysing a bit I got to know that my second interface is failing as similar members are already present in another dimension (S1Accounts) which I loaded initially. If I delete all the members in S1Accounts and execute the ODI Interface for S2Accounts again then it works fine and members get loaded into it.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!