Star Schema Formats

You select one of these extract format options when you create a star schema:

• Standard

• Metadata Only

• Selected Metadata Only

• Essbase

• Data Warehouse

The extract format option that you select determines the schema format used. Each schema format generates a different set of tables. These schema formats are available:

• Standard Essbase Schema - this schema is used for the Standard, Metadata Only, and Selected Metadata Only extract format types.

• SQL and Essbase Schema - this schema is used for the Essbase extract format type.

• Warehouse Normalized Hierarchy Schema - this schema is used for the Data Warehouse extract format type.