Adding or Removing Tables in a Minischema

After naming the minischema, as described in Setting General Properties for Minischemas, complete the tasks in this topic.

Note:

You may also access the Add/Remove dialog box from an existing minischema by right-clicking in the minischema work area and selecting Add/Remove Tables.

  To add or remove tables from a minischema diagram:

  1. In the Add/Remove Tables page, from Connections, select the data source from which to create the minischema.

    The Databases field displays the name of the database associated with this data source connection. This field is not editable.

    The Available Tables list is populated with the tables from the selected data source.

  2. Select the tables you want to include in the minischema, and click the Add selected tables to the schema button to move them to the Tables in Schema list.

    To move all available tables to the Tables in Schema list, click the Add all tables to the schema button.

  3. Optional: If you want to apply a filter to an object before moving it to the Tables in Schema list, enter the filter in the Filter text box.

  4. Optional: For minischemas based on relational sources, to add related tables to the minischema, select tables in the Tables in Schema list, and click the Add Related Tables button.

    You may want to add relational tables if, when you created the data source connection, you did not select all available tables during the schema population procedure (see Populating a Minischema).

  5. Optional: To add to the minischema objects from another data source:

    1. In Connections, select an alternate data source.

    2. Repeat step 2 through step 4 for all data sources from which you want to add objects to this minischema.

  6. To remove tables from the minischema, in the Tables in Schema list, select those that you want to remove and click the Remove selected tables from the schema button, which moves them to the Available Tables list.

    To move all tables in the schema to the Available Tables list, click the Remove all tables from the schema button.

    Removing tables from a minischema diagram does not remove or delete those tables from the data source connection on which the minischema is based.

    Note:

    When you want to remove a minischema table that has user-defined joins, Oracle recommends that you always delete those joins first, then delete the minischema table.

  7. Click Finish.

  8. In the Minischema work area of the Essbase Studio Console, review the new minischema diagram.

  9. Optional: To allow Essbase Studio to auto-arrange the tables in the minischema, click the Lay out schema button in the toolbar.

    Note:

    You may also auto-arrange the tables by right-clicking in the minischema work area.