Exporting Hierarchy Nodes in Generation Format

<Do not delete this text because it is a placeholder for the generated list of "main" topics when run in a browser>

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.

.

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

 

.

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.

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.


.

Click the Style tab.

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

 

.

Click the Filter tab.

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.

 

.

Click the Columns tab.

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

 

.

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.

 

.

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.

 

.

Click the Remove () button.

The Description property is displayed in the Available list.

 

.

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

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

 

.

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

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

 

.

Click the Target tab.

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.


.

Click the Run () button to process the export.

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.


.

Click Open.

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


.

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


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.

.

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

 

.

Click the New Export () button.

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


.

Click Version.

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

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.

 

.

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.

 

.

Click the Filter tab.

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.

 

.

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.

 

.

Click Add.

 

.

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.

 

.

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

 

.

Click OK.

The filter criteria is displayed in the Description field.

 

.

Click the Columns tab.

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

 

.

In the Category drop-down list, select Location.

 

.

In the Available list, click Continent.

 

.

Press the [Ctrl] key and click Country .

 

.

Click the Select () button.

Continent and Country are displayed in the Selected list.

 

.

In the Category drop-down list, select System.

 

.

In the Available list, click Name.

 

.

Click the Select () button.

The Name property is displayed in the Selected list.

 

.

In the Available list, click Description.

 

.

Click the Select () button.

The Description property is displayed in the Selected list.

 

.

Click the Target tab.

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


.

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


.

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.


.

Click the Run () button to process the export.

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.


.

Click Open.

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


.

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


Summary

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

Resources