You select one of these extract format options when you create a star schema:
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.