9 Build a Semantic Model's Physical Layer

This chapter contains information to help you understand how to build a semantic model's physical layer.

Topics:

• What is the Physical Layer?

• About Importing Metadata into the Physical Layer

• Create a Database and Add Tables to the Physical Layer

• Add a Catalog to a Database

• Add a Schema to a Database or Catalog

• Use a Variable to Dynamically Name a Catalog or Schema

• Change a Database Object's Database Type

• Modify a Database's Data Source Properties and Supported Query Features

• Work with Connection Pools

• About Physical Tables

• What Are a Physical Table's General Properties?

• Disable Auto Joins Creation in the Physical Layer

• Create a Physical Table

• Create or Modify a Physical Column

• Populate Physical Columns with a Stored Procedure or Select Statement

• About Physical Alias Tables

• Create an Alias Table

• Open the Physical Diagram from the Physical Layer

• Delete a Physical Table

• Delete a Physical Column

• Work with Physical Joins

• Use Hints in SQL Statements

• Preview Data in Physical Tables