This tutorial covers how to export hierarchy nodes.
Approximately 20 min.
Hierarchy exports are useful when you want to output nodes from selected hierarchies in a flat list or a parent-child relationship format. Examples of hierarchy exports include an outline for a financial report or a list of cost centers by geographic region.
For this type of export, configure the export wizard tabs as follows:
In this tutorial, you export hierarchy nodes.
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.
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.
|
---|---|
2. |
Double-click Planning - Detail to open the Planning - Export hierarchy export. Use the export wizard to edit the source, style, filter, columns, and target for the Planning - Detail export. You begin on the Source tab.
|
3. |
Use the Source tab to specify the source of data that you want to export. For a hierarchy node export, you select a version and one or more hierarchy/top node sets. You can select a normal, baseline, or as-of version. The Planning - Detail export is already configured to use the [Default Current Version] - 2010 03 - Production normal version and the TotalGeography/TotalGeography hierarchy/export top node set. In this example, you add the Function/Function hierarchy/top node set. Click the Add... button.
|
4. |
Use the Select Node dialog box to select a hierarchy and export top node. You can also search for a node. Perform the following actions in the Select Node dialog box:
|
5. |
Click OK.
|
6. |
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 all nodes, recurse from the top node, include inactive nodes, and remove duplicate nodes based on primary key columns.
|
7. |
Perform the following actions on the Style tab:
|
8. |
Click the Filter tab. Use the Filter tab to define the filter criteria for the exported data by using a validation, query, or text file. Only nodes that fail the validation or that meet the query criteria are included in the export results. The text file must contain a list of node names (one per line) to be included or excluded from the export.
|
9. |
In this example, you create a new private query filter to find nodes that have parents defined as budget planning points in the hierarchy branch.
Click the … ( Use the Query: New Query* dialog box to specify the query type and to enter filter parameters.
|
10. |
Click Add.
|
11. |
Perform the following actions:
|
12. |
In the Actions column, click the Update (
|
13. |
Click OK. The filter criteria is displayed in the Description field.
|
14. |
Click the Columns tab. Use the Columns tab to select properties for output columns and to configure column options. In this example, you leave the selected properties as is.
|
15. |
Click the Column Options tab. Use the Columns Options tab to configure pivot, defaults, and primary keys for the exported columns. In this example, you configure the Name and Parent Node properties as primary keys.
|
16. |
In the [Core] Name row in the Actions column, click the Edit button.
|
17. |
In the [Core] Name row, select the Primary Key option.
|
18. |
In the [Core] Name row, click the Update button.
|
19. |
In the [Core] Parent Node row in the Actions column, click the Edit button.
|
20. |
In the [Core] Parent Node row, select the Primary Key option.
|
21. |
In the [Core] Parent Node row, click the Update button.
|
22. |
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 export data to a server file named PlanningDetail.txt, which uses the DRM_Demo connection.
|
23. |
In the Device drop-down list, leave Server File selected to export data to a server file. Click the Test Connection... button to test the DRM_Demo connection to the server. The connection succeeded; therefore, you can finish configuring the target.
|
24. |
In the Confirmation dialog box, click OK.
|
25. |
In the File Name field, enter a server file name for storing the export results. For example, enter PlanningDetail.txt.
|
26. |
Click the Run ( The export is successfully processed.
|
27. |
Open the PlanningDetail.txt server file in Notepad to view the export results .
|
In this tutorial, you have learned how to export hierarchy nodes.