Exporting Hierarchy Nodes in Generation Format

Purpose

This tutorial covers how to export nodes in generation format.

Time to Complete

Approximately 30 min.

Overview

Exports in a generation or level-based format are useful when you want to output specific nodes and hierarchy ancestor levels as separate columns. Examples of exports in a generation format include products by line and group, vendors by country and city, and customers by territory and region.

You have two ways to export nodes in generation format: 

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

In this tutorial, you export nodes in generation format.

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 Nodes Using Generation Export

In this topic, you create a generation export and view the export results.

1.

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

Show Screenshot for Step

 

2.

Open the Generation Export named Income Statement DW, which outputs separate columns of nodes dynamically based on hierarchy structure. This method enables you to output balanced or unbalanced hierarchies.
Note: The Export Type column for this item states GenerationExport.

Double-click Income Statement DW.

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. Use the Source tab to specify the version and one or more hierarchy/top node sets that you want to export. You can select a normal, baseline, or as-of version. In this example, you leave the [Default Current Version] - 2010 03 - Production normal version selected.


3.

Click the Style tab.

Show Screenshot for Step

Use the Style tab to specify the type of nodes to be included in the export and to specify whether to include implicitly shared nodes. In this example, you export leaf nodes, recurse from the top node, include inactive nodes, and output the nodes in a top-down column order (root to node).

 

4.

Click the Filter tab.

Show Screenshot for Step

Use the Filter tab to define filter criteria (validation, inclusion filter, exclusion filter, and descendants file) for the exported data. Only nodes that fail the validation or that meet the query criteria are included in the export results. In this example, a private query is already defined. It finds nodes that have the Is Consolidated property equal to Y.

 

5.

Click the Columns tab.

Show Screenshot for Step

Use the Columns tab to select properties for output columns for each column set, and to configure column options.

 

6.

Use the Column Set drop-down list to configure the following:

  • Pre Columns—Properties to export at the beginning of each export record.
  • Bottom Node Columns—Properties for the specified bottom node.
  • Ancestor Columns—Node properties for the ancestor list of the specified bottom node. For example, if the bottom node is at level 10 in a hierarchy, then the output has 9 columns of ancestors. Ancestor columns are automatically generated at runtime.
  • Post Columns—Properties to export at the end of each export record.

In this example, no properties are selected to be displayed at the beginning of each export record.

In the Column Set drop-down list, select Bottom Node Columns.

Show Screenshot for Step

 

7.

Configure just the Name property to be displayed for the bottom node.
Note: The bottom node is the node being exported. In other words, it is the node at the end of the branch. It may be a leaf node or a limb node.

In the Selected list, click 2 - Description.

Show Screenshot for Step

 

8.

Click the Remove () button.

Show Screenshot for Step

The Description property is displayed in the Available list.

 

9.

In the Column Set drop-down list, select Ancestor Columns.

Show Screenshot for Step

In this example, the Name property will be displayed in the ancestor columns.

 

10.

In the Column Set drop-down list, select Post Columns.

Show Screenshot for Step

In this example, the Account Type and Currency properties will be displayed at the end of each export record.

 

11.

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. In this example, you leave Client File selected (it is the default), and you do not configure any other options.


12.

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.


13.

Click Open.

Show Screenshot for Step

The export results are displayed in Notepad. Separate columns of nodes are generated dynamically based on the Income Statement hierarchy structure.


14.

View the IncomeStatement hierarchy, which was opened for you, to compare it to the export results.

Show Screenshot for Step


Exporting Nodes Using Version Export

Another way to export generation data is to create a Version or Hierarchy export. This type of export outputs separate node-level properties to represent the different levels of a "virtual" hierarchy. In this example, you create a Version export that outputs a few properties for leaf nodes.

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 Version.

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 version that you want to export. You can select a normal, baseline, or as-of version. In this example, you leave the [Default Current Version] - 2010 03 - Production normal version selected. Click the Style tab.

Show Screenshot for Step

Use the Style tab to specify the type of nodes to be included in the export and to specify whether to include implicitly shared nodes.

 

5.

Perform the following actions on the Style tab:

  • Click the Leaf Nodes Only option.
  • Leave the Include Implicitly Shared Nodes option cleared. This option enables you to include descendant nodes below shared limb nodes that are explicitly shared. Implicit shared nodes are exported only if they are not filtered out by another option. If you use a query filter in the export, you must explicitly include the shared nodes.

Show Screenshot for Step

 

6.

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.

 

7.

In this example, you create a private query filter that finds nodes where the Continent property is equal to North America or South America. Click the (...) button.

Show Screenshot for Step

 

8.

Click Add.

Show Screenshot for Step

 

9.

Perform the following actions:

  • In the Property drop-down list, select Continent.
  • In the Operator drop-down list, select In.
  • In the Value field, enter North America,South America.

Show Screenshot for Step

 

10.

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

Show Screenshot for Step

 

11.

Click OK.

Show Screenshot for Step

The filter criteria is displayed in the Description field.

 

12.

Click the Columns tab.

Show Screenshot for Step

Use the Columns tab to select properties for output columns. In this example, you select the Continent, Country, Name, and Description properties.

 

13.

In the Category drop-down list, select Location.

Show Screenshot for Step

 

14.

In the Available list, click Continent.

Show Screenshot for Step

 

15.

Press the [Ctrl] key and click Country .

Show Screenshot for Step

 

16.

Click the Select () button.

Show Screenshot for Step

Continent and Country are displayed in the Selected list.

 

17.

In the Category drop-down list, select System.

Show Screenshot for Step

 

18.

In the Available list, click Name.

Show Screenshot for Step

 

19.

Click the Select () button.

Show Screenshot for Step

The Name property is displayed in the Selected list.

 

20.

In the Available list, click Description.

Show Screenshot for Step

 

21.

Click the Select () button.

Show Screenshot for Step

The Description property is displayed in the Selected list.

 

22.

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.


23.

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

Show Screenshot for Step


24.

Perform the following actions:

  • Select the Column Headings option to display column titles in the output.
  • In the Field Delimiter drop-down list, select (Comma) to indicate the field delimiter character and record delimiter character. In this example, you use commas for the field delimiter.

Show Screenshot for Step


25.

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.


26.

Click Open.

Show Screenshot for Step

The export results are displayed in Notepad. The following leaf node properties are outputted under the columns titled Continent, Country, Name, and Description.


27.

Scroll down to view additional rows that have all values in all columns.

Show Screenshot for Step


Summary

In this tutorial, you have learned how to export nodes in generation format.

Resources