Creating Metadata Elements from Text File Sources

Create metadata elements from the contents of the files in your text file 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.

  To create dimension elements from the physical objects of a text file data source:

  1. In Create Metadata Elements, select elements 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 dimension elements in a folder other than the default folder:

    1. Click Browse.

    2. In Select Folder, choose a folder from the Metadata Navigator in which to store the dimension elements, expanding the folders as necessary.

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

  3. Click Finish.

    If you created metadata elements, view them in the Metadata Navigator.

You are ready to begin creating other metadata elements, such as dimension elements and hierarchies.