Creating Import Profiles

Before importing dimensions into the Dimension Library or an application, you must create an import profile. Profiles include important information about the dimensions to be imported such as new dimensions, whether to merge or replace existing dimensions, and dimension properties.

You can import, edit, view, and delete import profiles. See Managing Import Profiles.

  To create an import profile:

  1. From the Dimension Library, select File, Import, Create Profile.

  2. Enter a profile name.

  3. From Import Type, select one of these import types:

    • Flat File: to import a text file

    • Interface tables: to import data from a database

    • Data Relationship Management: to import dimensions from Data Relationship Management. For information on preparing metadata for export from Data Relationship Management, see the Oracle Data Relationship Management Administrator's Guide

  4. Optional: Enter a description for the profile.

  5. If you want to import into the Dimension Library, select Shared Library, otherwise select an existing application.

    The Application list includes Shared Library and all existing applications that you have security access to in the Application Library.

  6. If you selected Flat File or Interface Tables as the Import Type, do one of the following:

    • If you selected Flat File in Step 3, click Browse, browse to find the file, and click Upload.

      Note:

      Performance Management Architect import supports text files in the ADS format with the following encodings: UTF-8, UTF-16LE, UTF-16BE, UTF-32LE, UTF-32BE. In addition, ASCII encoded files can also be read but are limited to English characters.
      You can use the New Profile dialog box to import a flat file into the Dimension Library.

    • If you selected Interface Table in Step 3, from Data Source, select the database to use for this profile.

      You can use the New Profile dialog box to import interface tables into the Dimension Library.

  7. Click OK.

  8. Click Next.

    • If you are importing from a flat file or from a Data Relationship Management application, now you will enter the file or application properties, respectively, as described in Entering Properties.

    • If you are importing from an interface table, now you will map dimensions, as described in Mapping Dimensions.