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.
- I wonder when I already enabled the allow duplicate members in the target cube then how I can let ODI know about this. Is there any setting or option I can set in ODI IKM for loading same members again but for different dimension???
NOTE: I am enclosing the screenshot of ODI error in the attachment file for ready reference
Any help would be highly appreciated.
Version
11.1.2.4
