Exporting Differences Using Compares

Purpose

This tutorial covers how to export differences using compares.

Time to Complete

Approximately 30 min.

Overview

Compare Exports are useful when you want to output the results of a hierarchy comparison process, which identifies differences in nodes, relationships, or properties between two hierarchies or two versions of the same hierarchy. For example, you export the differences for a hierarchy between the current normal version and its baseline version.

For this type of export, configure the export wizard tabs as follows:

In this tutorial, you export differences using compares.

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.

Exporting Differences Using Compares

In this topic, you create a Comparison export that outputs differences for the Employees hierarchy between now and 10 days ago.

1.

Begin by navigating to the Export task group. Use the Export task group to create and manage exports.

Show Screenshot for Step

 

2.

Click the New Export () button.

Show Screenshot for Step

Use the Choose Export Type dialog box to select an export type (hierarchy, comparison, version, property, or log).


3.

Click Compare.

Show Screenshot for Step

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

 

4.

Use the Source tab to specify the two hierarchies that you want to compare. You can select normal and baseline versions, and you can create as-of versions.

In the From Version drop-down list, select 2010 03 - Production.

Show Screenshot for Step

 

5.

Click the Normal link.

Show Screenshot for Step

Use the Version Parameters dialog box to configure the as-of version.

 

6.

Perform the following actions:

  • In the Version Type drop-down list, select the Create As-Of option.
  • In the As-Of Type drop-down list, select Transaction Date Offset (Days) option.
  • In the Offset Days field, enter 10.
  • Optional. In the Offset Time field, enter the desired time. For example, enter 11:25 AM.

Show Screenshot for Step

 

7.

Click OK.

Show Screenshot for Step

The Create As-Of link is displayed for the From Version.

 

8.

For the From Version, click the ... (...) button.

Show Screenshot for Step

Use the Select Node dialog box to specify the hierarchy and top node for the From Version. In this example, you select the Employees hierarchy and Employees top node.

 

9.

In the Select Node dialog box, perform the following actions:

  • In the Hierarchy drop-down list, select Employees..
  • Leave the Employees top node selected.

Show Screenshot for Step

 

10.

Click OK.

Show Screenshot for Step

 

11.

Use the To Version field to specify the second version. In this example, you specify the same version as the From Version; however, you use its normal version (the most current version).

Perform the following actions:

  • In the To Version drop-down list, select 2010 03 - Production.
  • Leave the Employees hierarchy and Employees top node selected.

Show Screenshot for Step

 

12.

Click the Style tab.

Show Screenshot for Step

Use the Style tab to specify the type of nodes (all, leaf, or limb) and type of actions (additions, deletions, moves, removes, and property updates) to be included in the export. You also specify a join property.

 

13.

Perform the following actions on the Style tab:

  • Leave the All Nodes option selected.
  • In the Join Property drop-down list, leave the default property, Name, selected. Use this field to specify the property that maps nodes from the From Version hierarchy to the To Version hierarchy.
  • Use the Include section to specify which actions you want to include in your comparison. For example, you select the Additions option because you want to export the nodes that were added in the last 10 days. Use the field below an action type to specify a custom label. You can include the label in an optional export column to identify the node change type in the export results. Select Additions, Renames, Deletions, Moves, and Property Updates options.

Show Screenshot for Step

 

14.

Click the Edit... button.

Show Screenshot for Step

Use the Select Properties dialog box to select the properties that you want to compare. In this example, you select the Description and Name properties.

 

15.

In the Available list, click Description.

Show Screenshot for Step

 

16.

In the Available list, scroll down, press the [Ctrl] key, and click Name.

Show Screenshot for Step

 

17.

Click the Select () button.

Show Screenshot for Step

The Description and Name properties are displayed in the Selected list.

 

18.

Click OK.

Show Screenshot for Step

 

19.

Click the Filter tab.

Show Screenshot for Step

Use the Filter tab to define filter criteria for the exported data. Only nodes that fail the validation or that meet the query criteria are included in the export results.

 

20.

In this example, you define a query to return nodes whose Node Inactive property is equal to False. Click the (...) button.

Show Screenshot for Step

Use the Query: New Query* dialog box to enter the query criteria.

 

21.

Click Add.

Show Screenshot for Step

 

22.

Perform the following actions:

  • In the Property drop-down list, select Node Inactive.
  • In the Operator drop-down list, select Equal.
  • In the Value field, enter False.

Show Screenshot for Step

 

23.

In the Action column, click the Update (Update) button.

Show Screenshot for Step

 

24.

Click OK.

Show Screenshot for Step

The filter criteria is displayed in the Description field.

 

25.

Click the Columns tab.

Show Screenshot for Step

Use the Columns tab to select global properties and column options (pivot, skip defaults, and primary key) for the selected properties.

 

26.

In the Category drop-down list, select Export Specific.

Show Screenshot for Step

 

27.

In the Available list, click [Action Type Code].

Show Screenshot for Step

 

28.

Click the Select () button.

Show Screenshot for Step

[Action Type Code] is displayed in the Selected list.

 

29.

In the Category drop-down list, select System.

Show Screenshot for Step

 

30.

In the Available list, click Name[From].

Show Screenshot for Step

 

31.

Press the [Ctrl] key and click Name[To].

Show Screenshot for Step

 

32.

Click the Select () button.

Show Screenshot for Step

Name[From] and Name[To] are displayed in the Selected list.

 

33.

In the Available list, scroll down and click Parent Node[To].

Show Screenshot for Step

 

34.

Click the Select () button.

Show Screenshot for Step

Parent Node[To] is displayed in the Selected list.

 

35.

In the Available list, scroll up, click Description[From], then press the [Ctrl] key and click Description[To].

Show Screenshot for Step

 

36.

Click the Select () button.

Show Screenshot for Step

Description{From] and Description[To] are displayed in the Selected list.

 

37.

Click the Target tab.

Show Screenshot for Step

Use the Target tab to configure where the data is to be exported and the format of the exported results.


38.

In the Device drop-down list, select Client File to export data to a client file.

Show Screenshot for Step


39.

Perform the following actions:

  • Select the Column Headings option to display column titles in the output.
  • In the Field Delimiter drop-down list, select (Other) to indicate the field delimiter character and record delimiter character. In this example, you use a single pipe (|) for the field delimiter.
  • In the Field Delimiter field, enter "|".

Show Screenshot for Step


40.

Click the Run () button to process the export.

Show Screenshot for Step

The File Download dialog box is displayed. Use the File Download dialog box to open or save the export results. You can also cancel the export, if necessary.


41.

Click Open.

Show Screenshot for Step

The export results are displayed in Notepad. The first row contains column headings.


Summary

In this tutorial, you have learned how to export differences using compares.

Resources