Exporting Global Nodes

Purpose

This tutorial covers how to export global nodes.

Time to Complete

Approximately 20 min.

Overview

Exporting global nodes is useful when you want to output a list of nodes from a version without specifying hierarchy information; for example, a master list of projects, a report of inactive customers, or a list of employees who are not assigned to a cost center.

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

In this tutorial, you export global nodes.

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 Global Nodes

In this topic, you create an 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.

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 the Query list, select North America Cost Centers.

Show Screenshot for Step

The Description field displays the query criteria.

 

8.

Click the Columns tab.

Show Screenshot for Step

Use the Columns tab to select global properties for the export. In this example, you export Name, Description, and Region (in that order).

 

9.

In the Available list, click Description.

Show Screenshot for Step

 

10.

Click the Select () button.

Show Screenshot for Step

The Description property is displayed in the Selected list.

 

11.

In the Available list, click Name.

Show Screenshot for Step

 

12.

Click the Select () button.

Show Screenshot for Step

The Name property is displayed in the Selected list.

 

13.

Click the Category drop-down list.

Show Screenshot for Step

 

14.

In the Category drop-down list, select Location.

Show Screenshot for Step

 

15.

In the Available list, click Region.

Show Screenshot for Step

 

16.

Click the Select () button.

Show Screenshot for Step

The Region property is displayed in the Selected list.

 

17.

Make the Name property the first in the Selected list. Click 2 - Name.

Show Screenshot for Step

 

18.

Click the Move Up () button.

Show Screenshot for Step

The Name property is displayed first in the Selected list.

 

19.

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.


20.

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

Show Screenshot for Step


21.

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


22.

Click the Save As () button to save the export to the repository .

Show Screenshot for Step

Use the Save Export As dialog box to specify a name, a description, and an access level for your export.


23.

In the Save Export As dialog box, perform the following actions:

  • In the Name field, enter North America Cost Centers.
  • Optional. In the Description field, enter a meaningful description of the new export. For example, enter North America Cost Centers.
  • 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 blender
    • Standard—Enables all users to run the blender, but only users with the Data Manager role can edit it

Show Screenshot for Step


24.

Click OK. The tab name is displayed as North America Cost Centers.

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.


Summary

In this tutorial, you have learned how to export global nodes.

Resources