My Oracle Support Banner

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 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.2.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

Became:
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?

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.