Prepare the Semantic Model for Migration to Semantic Modeler

Check and prepare the semantic model to ensure a successful migration.

To learn more about how Semantic Modeler handles the migration and the types of issue you might need to fix after the migration, see Update the Semantic Model After Migration From Model Administration Tool.

Item	Description
Data sources	Confirm that the semantic model uses a data sources that Semantic Modeler supports. Semantic Modeler supports only relational data sources. Be sure to remove or replace any unsupported data sources in the semantic model before migration. See Data Sources Available for Data Modeling.
Logical dimension (hierarchy) based on two logical tables	Check that any logical dimension (hierarchy) is based on only one logical table (dimension table). Semantic Modeler doesn't support logical dimensions (hierarchies) based on two logical tables. For example, a dimension table and a dimension extension logical table. To fix this issue before migration, go to Model Administration Tool and combine the two logical tables (for example, dimension table and dimension extension table) into one logical table.
Logical foreign key joins	Check if the semantic model contains logical foreign key joins. Logical foreign key joins don't exist in Semantic Modeler and won't be included with the migration. Before you migrate the model, be sure to delete the logical foreign key joins and replace them with logical joins.
Primary keys	Check that all of the semantic model's logical levels contain primary keys.
Consistency check	The semantic model must pass consistency check before migration. In Model Administration Tool, run consistency check on the model and fix any errors before migration.