Setting Cube Schema Options

In the Cube Schema Wizard, use the Setting Cube Schema Options page while creating or editing a cube schema. Options you specify are whether to override the default data load mappings and to create an Essbase model from a cube schema.

  To set options in the Cube Schema Wizard:

  1. Optional: In the Cube Schema options page, select the Override default data load bindings check box if you want to define the default load members and data load bindings.

    Note:

    You must select the Override default data load bindings check box if your cube schema includes a calendar hierarchy.

    If the hierarchies, measures, or measure hierarchy come from different data sources, you may want to override the default data load bindings in order to minimize errors during cube deployment.

    When you select this check box, the Next button is enabled. See Defining Data Load Mappings for information on completing the Define Data Load Mappings page of the wizard.

  2. Optional: Select Create Essbase Model to create an Essbase model from this cube schema, and complete these steps:

    1. Enter a Model Name.

    2. If only one measure has been specified as the Measure for the cube schema, then in Accounts Dimension, specify the hierarchy from which the accounts dimension for this model will be generated.

      When multiple measures are specified as the Measure for the cube schema, the accounts dimension is created with the measures as the members. When measure hierarchy is specified, then it is tagged as the accounts dimension.

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

  3. For Performance Management Architect-based models only: In Model Type, select whether data storage type for this model will be Aggregate Storage or Block Storage.

    Note:

    You must choose the data storage type during the cube schema creation process. You cannot change it in the Essbase model.

  4. Click Finish to begin building the cube schema and, if you specified it, the Essbase model.

    Alternatively, if you selected the Override default data load bindings check box in step 1, click Next and follow the instructions in Defining Data Load Mappings.

    Note:

    If you encounter an out-of-memory error when working with a cube schema, increase the virtual memory setting for Essbase Studio Console, as described in Configuring Virtual Memory.

  5. Optional: When the process is complete, review the graphical representation of the Essbase model in the Essbase Studio Console work area.