Creating and Running Imports

Purpose

This tutorial covers how to create and run imports in Data Relationship Management (DRM) Web Client.

Time to Complete

Approximately 30 min.

Overview

You create imports in the Import task group in DRM Web Client. An import wizard, which consists of the following tabs, guides you through the process of defining the import source, style, columns, filters, and target: 

You must first open an import to run it. If you import a file from your client machine, you must also select a client file before you can run the import. After running an import, you can view summary information and detailed messages in the import results.

The import results identify the completion status of the process, the statistics for errors, and the statistics for hierarchies, nodes, and orphans. Warning and error messages are displayed below the summary information. You can download import results to an external CSV, PDF, RTF, or XLS file. 

The import process creates a new version of data in the application and loads it in a detached (unsaved) state. The version includes the hierarchies, nodes, and property values that were successfully imported. You can permanently save the version for future use or blend it into another version. If the version is incorrect, you can discard it and import it again.  

In this tutorial, you create and run an import.

Prerequisites

Before starting this tutorial, you should have access to or have installed Oracle Hyperion Enterprise Performance Management 11.1.2.1.0 and Oracle Hyperion Data Relationship Management, Fusion Edition 11.1.2.1.0.

Creating an Import

In this topic, you create an import.

1.

Begin by navigating to the Import task group. Use the Import task group to create and manage imports.

Show Screenshot for Step

 

2.

Click the New Import (New Import) button.

Show Screenshot for Step

Use the import wizard to define the source, style, columns, filters, and target for the import. You begin on the Source tab.


3.

Perform the following actions on the Source tab:

  • In the Device field, leave the Client File option selected to specify that the import file is a client file.
  • For the File Location field, click the Browse button, navigate to a local folder that contains the import file (for example, C:\DRM\ImportMA.txt), and select the import file.
    In this example, the import file has four sections: [hierarchy], [node], [relation], and [hiernode].

    Show Screenshot for Step

  • In the Delimited fields, leave the (Other) option selected and enter a single pipe "|" as the delimiter.
  • Use the Prefix Delimiter and Suffix Delimiter fields to enter characters to be displayed at the beginning and end of a section heading; for example, /, /**, or [. The suffix delimiter is optional. In this example, you leave the fields as is.
  • Clear the Version option to indicate that the import file does not have a Version section.
  • In the Hierarchy field, enter hierarchy to match the name of the Hierarchy section in the import file.

Show Screenshot for Step

 

4.

Click the Style tab.

Show Screenshot for Step

Use the Style tab to define relationship sorting, determine leaf nodes, enforce invalid node name characters, and specify duplicate handling options.

 

5.

Perform the following actions on the Style tab:

  • Select the Determine Leaf Nodes at the end of Import Process option to indicate that leaf nodes are not explicitly identified in the import file (which is often). Data Relationship Management automatically flags a node as a leaf if it is imported into a hierarchy without any children.
  • Leave the Enforce Invalid Node Name Characters field cleared to allow nodes with invalid characters. You can use this field to stop nodes from being imported if their names include invalid characters, which are defined in the InvName system preference for the application.
    For example, suppose your application does not permit commas in node names; however, you want to import nodes that do include commas (for example, "Smith, John"). You can select this field to override the system preference and allow the nodes to be imported.
  • In the Duplicate Handling section, leave the defaults. You can use this section to specify how to uniquely name duplicate instances of a node in a hierarchy. The default is to append the suffix :Shared- and an incrementing number; for example, P0005:Shared-001. You can relate duplicate nodes by selecting an associated nodes property. You can also specify a duplicate error mode to determine whether a duplicate node is included in the Max Errors count for the import profile.

Show Screenshot for Step

 

6.

Click the Columns tab.

Show Screenshot for Step

Use the Columns tab to map properties to columns in the import file and map columns to hierarchies. In the Selected list, columns that are marked with an asterisk (*) are mandatory.

 

7.

In the Section drop-down list, select Hierarchy.

Show Screenshot for Step

 

8.

In this example, the Hierarchy section in the import file has two properties: hierarchy name and top node; therefore, you need to remove the Hier Desc property from the Selected list. In the Selected list, click 3 - Hier Descr.

Show Screenshot for Step

 

9.

Click the Remove () button.

Show Screenshot for Step

The Hier Descr property is removed from the Selected list.

 

10.

In the Section drop-down list, select Node.

Show Screenshot for Step

 

11.

In this example, the Node section in the import file has two properties: node name and node description; therefore, you need to remove the Leaf property from the Selected list. In the Selected list, click 3 - Leaf.

Show Screenshot for Step

 

12.

Click the Remove () button.

Show Screenshot for Step

The Leaf property is removed from the Selected list.

 

13.

In the Section drop-down list, select Relation.

Show Screenshot for Step

 

14.

In this example, the Relation section in the import file has two properties: parent node and child node; therefore, you need to remove the Description and Leaf properties from the Selected list. In the Selected list, click 3 - Description.

Show Screenshot for Step

 

15.

Press the [Ctrl] key and click 4 - Leaf.

Show Screenshot for Step

 

16.

Click the Remove () button.

Show Screenshot for Step

The Description and Leaf properties are removed from the Selected list.

 

17.

In the Section drop-down list, select Hierarchy Node.

Show Screenshot for Step

 

18.

In this example, the Hierarchy Node section in the import file has four columns: hierarchy name, node name, alias, and a column that should not be imported; therefore, you need to add two columns to the Available list. In the Category drop-down list, select Essbase.

Show Screenshot for Step

 

19.

In the Available list, click Alias.

Show Screenshot for Step

 

20.

Click the Select () button.

Show Screenshot for Step

The Alias property is displayed in the Selected list.

 

21.

In the Available list, click [Ignore Column].

Show Screenshot for Step

 

22.

Click the Select (Select) button.

Show Screenshot for Step

The [Ignore Column] property is displayed in the Selected list.

 

23.

Click the Filters tab.

Show Screenshot for Step

Use the Filters tab to skip blank values and default values for defined, inheriting, and derived properties during the import process. In this example, you accept the default selections.


24.

Click the Target tab.

Show Screenshot for Step

Use the Target tab to specify a name and description for the new version and to specify the maximum number of errors that can occur during the processing before the import stops.

Note: You specify a version name and description only if your import file does not have a Version section to define those values.


25.

In the Version Name field, enter ImportMA.

Show Screenshot for Step


26.

Click the Save (Save) button.

Show Screenshot for Step

Use the Save Import dialog box to specify a name and description for the import, and select an object access level.


27.

In the Save Import dialog box, perform the following actions:

  • In the Name field, enter ImportMA.
  • Optional. In the Description field, enter a meaningful description of the new import.
  • In the Object Access Level drop-down list, select Standard. The Object Access Level field assigns one of the following access levels:
    • User—Enables only you to run and edit the import.
    • Standard—Enables all users to run the import, but only users with the Data Manager role can edit it.

Show Screenshot for Step


28.

Click OK.

Show Screenshot for Step

The tab name is displayed as ImportMA.


29.

Close the ImportMA tab.

Show Screenshot for Step

Your import is listed in the Import task group under Standard Imports.


Running an Import

In this topic, you run an import.

1.

Click the standard import named ImportMA.

Show Screenshot for Step

 

2.

Point to the Imports drop-down list.

Show Screenshot for Step

 

3.

In the Imports drop-down list, select Open.

Show Screenshot for Step

Use the import wizard to modify the source, style, columns, filters, and target of the import named ImportMA.

 

4.

Click the Browse... button to select an import file for the source file.

Note: You must select an import file each time you run an import.

Show Screenshot for Step

Use the Choose File to Upload dialog box to browse to and select an import file.

 

5.

Click the ImportMA.txt file.

Show Screenshot for Step

 

6.

Click Open.

Show Screenshot for Step

 

7.

Click the Run (Run) button to process the import.

Show Screenshot for Step

The processing results are displayed. They indicate the completion status of the process; the statistics for errors; the statistics for hierarchies, nodes, and orphans that were created; and warning and error messages. In this example, the import was completed successfully and you have no warnings or error messages. The statistics show that 5 hierarchies, 123 nodes, and 2 orphan nodes were added. No duplicate nodes were found.

 

8.

Close the import.

Show Screenshot for Step

 

9.

Click Browse to navigate to the Browse task group.

Show Screenshot for Step

The ImportMA version is listed in the version list in the Browse task group. It is created in a detached state (not saved).

 

10.

Click the Orphans tab.

Show Screenshot for Step

The import added two orphan nodes (CC05 and None).

 

11.

Click the Hierarchies tab.

Show Screenshot for Step

 

12.

Click the BalanceSheet tab to open a hierarchy that was created by the import.

Show Screenshot for Step

Use the BalanceSheet - ImportMA hierarchy tab to view and manage nodes in the BalanceSheet hierarchy.

 

13.

Click the Home tab.

Show Screenshot for Step

You determined that the import created what you expected. Now you can save the version.

 

14.

Right-click the ImportMA version.

Show Screenshot for Step

 

15.

Click Save.

Show Screenshot for Step

The ImportMA version is saved to the repository database.

 

Summary

In this tutorial, you have learned how to create and run an import.

Resources