OBIEE12c Admin Tool Import Metadata - Creates Incorrect FKs
(Doc ID 2583645.1)
Last updated on DECEMBER 13, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Analytics
OBIEE12c Admin Tool imports metadata - creates incorrect FKs
After the import of metadata we found that many of the foreign key relationships are incorrect. It appears the import simply looked for similarly named fields and if a matching column wasn't found, it chose the table's pk.
For e.g should be:
table_x.abc => table_y.xyz_abc
table_x.abc => table_y.pk
It made these definitions, even though the datatypes aren't the same. It also appears to have changed multi key relationships to only have one key defined.
Is there a more correct way to handle these problems than to rely on manual effort and human error?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document