Have access to or have installed Oracle® Hyperion Financial Management, Fusion Edition 11.1.1.0.0

Have access to or have installed Hyperion® Foundation Services 11.1.1.0.0

1.

Navigate to Start > Programs > Oracle EPM System > Foundation Services > EPM System Configurator, and click Next.

2.

Expand Foundation > Performance Management Architect and, in the expanded list, select Interface Datasource Configuration. Click Next.

Select Create a new datasource link, and click Next.

Select Oracle, and click Next.

Perform the following actions:

a) Enter the following property values for the interface data source:

b. Select Create Interface tables

c. Click Next.

Click Yes to delete all existing tables.

Click Next.

Verify that the interface data source configuration is completed, and click Finish.

You can now use any SQL load program or data transfer tool to extract data from the external source into the interface table.

On your desktop, double-click the Workspace icon, and enter user name trnadmin and password hyperion. Click Log On to log on to Workspace.

In Workspace, select Navigate > Administer> Data Synchronization.

Select File > New > Data Interface Table Definition.

The Data Interface Area Mapping Wizard is displayed.

Select the following values for the interface area, and click Next.

On the Dimensions page, map each dimension of your application to the appropriate column, and click Next.

On the Properties page, enter the following property for the interface table, and click Finish.

Select View > Refresh.

The TrainingLoad interface area is displayed in the Data Synchronization window.

Select File > New > Synchronization.

Select Hyperion Data Interface Area, and click Next.

On the Select Source page, select TrainingLoad, and click Next.

On the Select Destination page, select Training, and click Finish.

Verify that dimensions of the interface area (Source) and Training application (Destination) are mapped as follows:

Note: Dimensions are automatically mapped if their names are the same. You can manually map dimensions when the names are different.

Click Save, save the synchronization with the following information, and click OK.

Select the Data Synchronizer tab.

Select View > Refresh.

The Training synchronization is displayed in the Data Synchronizer window.

Right-click the Training synchronization, and select Validate Synchronization.

Click OK.

Click Close.

Right-click the Training synchronization, and select Execute Synchronization.

Click OK.

Click Close.

Select Navigate > Administer > Library Job Console, and select the job whose description is Executing synchronization: Training.

Verify that synchronization is completed successfully and that data is imported from the interface table into the Training application.

Select Navigate > Administer > Dimension Library.

Select File > Import > Create Profile.

Enter the following information for the new profile, and click OK.

The dimensions defined in the interface tables are displayed.

Enter the following details to map the dimensions:

a) For each dimension in the Interface area, enter the following dimensions in the Shared Library column:

b. In the Merge/Replace column, verify that Merge is selected.

c. Click Next.

Click Finish.

Click Yes.

Click Close.

Select Navigate > Administer > Library Job Console, and perform the following actions:

a. Select the job with the description Import 'Metadata1' into Application 'Training', and verify that the import was completed successfully.

b. Click Import Results to review the results .

Select the Dimension Library tab, and select View > Refresh.

The imported dimensions are displayed in Shared Library.

To learn more about Financial Management, refer to additional OBEs.