Deleting Tables from Data Source Connections

Consider deleting tables that are no longer in use or that you do not want used with a particular data source connection.

You can delete tables from data source connections as long as no Essbase Studio metadata elements are dependent on the tables. For example, if a table is used to build a hierarchy stored in your Essbase Studio catalog, you cannot delete the table without first deleting the dependent hierarchy and its elements.

Note:

You can only delete tables from relational data sources, including Oracle BI EE data sources, and files from flat file data sources.

  To delete tables from a data source connection:

  1. In Source Navigator, on the Data Sources tab, select a table.

    Use the Shift or Ctrl keys to select multiple tables.

    Note:

    If you want to delete all tables from a data source connection, Oracle recommends deleting the data source connection (see Deleting Connections) and creating a new connection.

  2. Right-click the table, and then select Delete.

  3. If no tables are used by metadata elements or have joins to other tables, in the Confirm Delete dialog box, click Yes.

    The Confirm Delete dialog box is displayed when no metadata elements depend on the selected tables.

  4. If the selected tables are used by other metadata elements or have joins to other tables, perform these actions:

    1. Review the metadata elements listed in the Errors and Warnings section of the Delete dialog box, and click Cancel.

      Tip:

      Before clicking Cancel, click the Save Errors and Warnings button to save the list of tables as a text file, which can be used for reference in step 4.b.

    2. Delete the noted metadata elements and all related metadata elements (see Deleting Metadata Elements).

      Note:

      The Lineage Viewer can help you to quickly see dependent metadata elements, including Essbase models and cube deployments. Close the Delete dialog box, right-click a metadata element in the Metadata Navigator, and select View Lineage.

    3. After deleting all dependent metadata elements, repeat the process by selecting a table to delete in the Source Navigator, and selecting Delete.

    4. If the selected tables have joins with other tables, in the Delete dialog box, under Table Status, select the check box next to the table name to delete, and then click Delete.

      If no other metadata element dependencies exist, the selected tables and joins listed for the selected table are deleted.

  5. Verify that the table is deleted in the Source Navigator.