Use a Variable to Dynamically Name a Catalog or Schema

You can use variables to dynamically name the physical layer's catalogs and schemas.

For example, suppose you have data for multiple clients and you structured the data source so that data for each client is in a separate catalog. In this case, you can initialize a session variable named Client that dynamically sets the name for the catalog object when a user signs into Oracle Analytics.

See About Session Variables.

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. Browse for and double-click the catalog or schema that you want to add the variable to.
5. In the item's General pane click Select.
6. In Select Variables, locate and click the variable that you want to use. Click Select.
7. Click Save.