Add a Catalog to a Database

You can add catalogs to the physical layer's databases to group a semantic model's schemas and tables to mirror how the data source is organized.

You can't rearrange the catalog and schema groupings that you add. For example, if you added a schema and tables directly into a database, then you can't later create a catalog and move them to the catalog.

See Add a Schema to a Database or Catalog.

You can use a variable to dynamically populate the catalog's name. See Use a Variable to Dynamically Name a Catalog or Schema.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer.
  4. Click Create and then click Create Catalog.
  5. In Create Catalog, locate the Name field and type a catalog name.
  6. In Location, click the menu and specify which database to add the catalog to.
  7. Click OK.