Types of Semantic Model Consistency Checks

There are two consistency checks that you can run: Check Consistency and Advanced Check.

Check Consistency

Check Consistency examines individual semantic objects and their relationships to other objects and finds certain kinds of errors and inconsistencies. You can run Check Consistency on an individual object, a group of selected objects, or the whole semantic model. Run Check Consistency and resolve all errors before you run Advanced Check.

Here are some examples of what running Check Consistency does:

  • Finds any logical tables that don't have logical sources configured.
  • Finds any logical columns that aren't mapped to physical sources.
  • Checks for undefined logical join conditions.
  • Determines if any physical tables referenced in a business model aren't joined to the other tables referenced in the business model.
  • Checks if each business model has a corresponding subject area.

While you're developing the semantic model, Oracle recommends that you run Check Consistency on objects and the whole model to find and fix any errors. See Check the Consistency of a Semantic Model.

Advanced Check

Run Advanced Check before you deploy the semantic model.

To successfully deploy a semantic model, it must pass the Advanced Check. However, to troubleshoot migration issues, a semantic model doesn't have to pass the Advanced Check. You can convert a semantic model that passed only Check Consistency to a .rpd file, but be aware that it might contain issues that prevent query generation.

The Advanced Check does the following:

  • Runs Check Consistency to check the whole model. The consistency check must be error-free before Semantic Modeler can perform the advanced checks.

    If the Advanced Check runs Check Consistency and finds any errors, then only Check Consistency errors are displayed. Advanced Check errors aren't found and displayed until all Check Consistency errors are resolved.

  • Converts the semantic model from SMML to a .rpd file and runs advanced checks on the .rpd. If the model contains Check Consistency errors, Advanced Check can't convert it from SMML to a.rpd file and perform advanced checks.
  • Looks for scenarios with query generation navigation space errors.