Warehouse Schema Modeler -- Overview

Use the Warehouse Schema Modeler window to generate and store generic warehouse schema models that are associated with a data warehouse. The warehouse schema models can be easily exported as metadata to the OLAP Integration Server (as an OLAP model).

Authorities and privileges

Tasks

• Defining a warehouse schema

• Updating a warehouse schema

• Adding tables and views to the warehouse schema

• Autojoining tables

• Adding join relationships between non-keyed columns

• Removing join relationships

• Removing a warehouse schema

• Exporting a warehouse schema to the OLAP Integration Server

Related information

• Setting up page options