Metadata Conversion Rules and Error Messages

When the Generator creates the output files, it also maps the metadata objects in the Oracle BI repository to similar objects in the metadata of the Oracle Database.

This section explains the rules used to identify metadata that can't be translated (converted) into either SQL or XML format. These rules are necessary because Oracle Database and IBM Cube Views don't support some of the metadata constructs that are allowed by Oracle Analytics Server.

Dimensional metadata in the SQL or XML file is generated at the logical fact table source level. If a logical fact table source has an invalid logical dimension table source, then the logical dimension table source is invalidated. If the logical fact table source is invalid, then all the logical dimension table sources that are mapped to it are also be invalidated. Invalid repository metadata elements aren't converted to cubes in the SQL or XML file.

When a rule is violated, the Generator writes the error messages and the metadata that violated the rule to the log file.