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 Physical layer icon.
  4. Click Create Create icon 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.