1. Administrator's Guide
  2. Working With Dimensions
  3. Managing Dimension Members
  4. Importing Dimension Members

Importing Dimension Members

Administrators and Power Users can import dimension members from standard flat comma-separated value (CSV) files.

To import dimension members:

  1. In your application, select Manage, and then Dimensions.
  2. Select a dimension.
  3. In Members and Attributes, click Actions, and then Import Import button.
  4. Click Browse, and then navigate to the file you want to import.
  5. Select one of the following:

    • Replace—Replace dimension members with the definition in the import file. Replaces the member with the member in the file that you are importing. It does not affect other members that are not specified in the import file.

    • Update—Update some member attributes.

  6. Date Format

    Note:

    This feature is available only in 11.1.2.4.100 (patch 20307212). For information about new features and updating to release 11.1.2.4.100, see My Oracle Support https://support.oracle.com

    Select a Date Format from the drop down list of allowed date formats. Date formats are not translated. By default, the date format is set to the locale date format of the exported file location.

    For example:

    • MM/dd/yyyy

    • dd/MM/yyyy

    • dd-MMM-yy

    • MMM d, yyyy

  7. Select a File Delimiter for the import file: Comma or Tab. Comma is selected by default
  8. Click Import.
  9. The Results screen displays the number of imported dimension members.
  10. Click OK or Reset. The Reset button clears the dialog, and you can select another file to import. The imported members are saved with the import.