Conversion Rules for Oracle Databases

Learn the rules for converting Oracle BI metadata into objects.

The following list provides the rules for converting Oracle Analytics Server metadata into objects in the Oracle Database:

• Attributes that contain expressions in the logical table can't be exported.

• Tables joined using complex joins aren't considered.

• Tables that are opaque views aren't considered.

• Columns used as part of a key in one level can't be used as part of another level key.

  Oracle Database prohibits the use of columns as keys in multiple levels. This prohibition requires the Oracle Database Metadata Generator to eliminate one of the two joins, usually the join that's encountered first. Therefore, the other joins are lost, which prevents them from being exported.