Creating Essbase Models from Existing Cube Schemas

If you did not select the option to create an Essbase model during cube schema creation, you can create one anytime from the existing cube schema.

  To create an Essbase model from a cube schema:

  1. In the Metadata Navigator, navigate to the cube schema from which you want to create an Essbase model.

  2. Right-click the cube schema and select Create Essbase Model.

  3. In the Essbase Model dialog box, enter a Model Name.

  4. Optional: Provide a Description.

  5. In Accounts Dimension, specify the hierarchy from which the accounts dimension for this model will be generated.

    To allow Essbase Studio to generate the accounts dimension, select System generated.