physical schema

Creating Physical Layer Catalogs and Schemas



Catalogs are optional ways to group different schemas. A catalog contains all the schema (metadata) for a database object. A schema contains only the metadata information for a particular user or application. Model the physical layer after the way your database is structured.
A database can have either catalogs or schemas but not both. If your database has one or more schemas, you cannot create a catalog. If your database has one or more catalogs, you cannot create schemas.
NOTE:  You must create a database object before you create a catalog object or a schema object.

Creating Catalogs

In the Physical layer of a large repository, Oracle BI Administrators can create catalogs that contain one or more physical schemas.
To create a catalog
  1. In the Physical layer, right-click a database object, and then choose New Object > Physical Catalog.
  2. In the Physical Catalog dialog box, type a name for the catalog.
  3. Type a description for the catalog, and then click OK.

Creating Schemas

The schema object contains tables and columns for a physical schema. Schema objects are optional in the Physical layer of the Administration Tool.
To create a schema
  1. In the Physical layer, right-click a database object, and then choose New Object > Physical Schema.
  2. In the Physical Schema dialog box, type a name.
  3. Type a description for the schema, and then click OK

Using a Variable to Specify the Name of a Catalog or Schema


You can use a variable to specify the names of catalog and schema objects. For example, you have data for multiple clients and you structured the database so that data for each client was in a separate catalog. You would initialize a session variable named Client, for example, that could be used to set the name for the catalog object dynamically when a user signs on to the Oracle BI Server.
NOTE:  The Dynamic Name tab is not active unless at least one session variable is defined.
To specify the session variable to use in the Dynamic Name tab
  1. In the Name column of the Dynamic Name tab, click the name of the session variable that you want to use. The initial value for the variable (if any) is shown in the Default Initializer column.
  2. To select the highlighted variable, click Select.
    The name of the variable appears in the dynamic name field, and the Select button toggles to the Clear button.
To remove assignment for a session variable in the Dynamic Name tab
  • Click Clear to remove the assignment for the variable as the dynamic name.
    The value Not Assigned displays in the dynamic name field, and the Clear button toggles to the Select button.

To sort column entries in the Dynamic Name tab
  • You can sort the entries in a column by clicking on the associated column heading, Name or Default Initializer. Clicking on a column heading toggles the order of the entries in that column between ascending and descending order, according to the column type.
    When no dynamic name is assigned, Not Assigned displays in the dynamic name field to the left of the Select button. When a dynamic name is assigned, the Select button toggles to the Clear button, and the name of the variable displays in the dynamic name field.