Creating Metadata Elements for Relational Sources

Create metadata elements from the tables and columns in your data source. These metadata elements can be used later to create dimension elements and hierarchies, which you can then use to build a cube schema.

Note:

This procedure applies to Oracle BI EE data sources that are created with the Presentation Layer option selected. If you have created a data source for Oracle BI EE using the Business Model option, see Creating Oracle BI EE Dimensions.

  To create metadata elements:

  1. In Create Metadata Elements, in the Available Source Objects list, select which tables and columns to add to the folder for this data source in the Metadata Navigator.

    • To create metadata elements for all columns within all tables, select the check box next to the data source name at the top of the Available Source Objects list.

    • To create metadata elements for selected tables, including all their columns, select the check box next to the table names that you want to add.

    • To create metadata elements for selected columns of a table, expand the table and select the check boxes next to the names of the columns that you want to add.

  2. Optional: To store the metadata elements in a folder other than the default folder:

    1. Click Browse.

    2. In Select Folder, navigate to the folder in which you want to store the metadata elements, expanding the folders as necessary.

      Alternatively, click New Folder, enter the folder name in the text box, and click OK.

  3. Click Finish.

    View the new metadata elements listed in the Metadata Navigator.

    If you created a minischema, view the new minischema in the minischema work area of the Essbase Studio Console.