This tutorial shows you how to use interface tables as data sources for application dimensions.
Approximately 30 minutes
This tutorial covers the following topics:
|Configuring interface data sources|
|Creating interface table definitions|
|Importing dimensions from interface tables|
Click icon to show all screenshots
Note: Alternatively, you can click an individual icon (or image) associated with each step to view (or hide) the screenshot associated with that step.
This tutorial covers how to import dimensions using interface tables.
The focus of this tutorial is to illustrate how you can configure and use interface tables to import dimensions from external systems to Performance Management Architect
Metadata from your external systems need to be imported to applications in Oracle's Hyperion Enterprise Performance Management Architect. As Administrator, you are tasked to:
|1.||Move information from an ERP system or general ledger system into an ETL system.|
|2.||Move information from the ETL system into Performance Management Architect interface tables.|
|3.||Import interface tables into the Dimension Library.|
Before starting this tutorial, you should:
|1.||Have access to the Configuration Utility.|
|2.||Have Administrator access to Performance Management Architect.|
|3.||Have access to data sources containing dimension metadata.|
Configuring data sources is required if you want to use interface tables in Performance Management Architect. Interface tables provide a database interface that enables you to import of metadata and data from external systems into the Dimension Library.
In this topic, you configure data sources for interface tables.
Click Start > Programs > Hyperion > Foundation Services > Configuration Utility, and click Next.
In the product selection panel, under Hyperion System 9 BPM Architect, select Interface Datasource Configuration.
Enter the Shared Services server, port, user name and password, and click Next.
Select Create a new datasource link, and click Next.
Select a database type (Oracle, SQL or DB2), and click Next.
Enter the details for the interface data source, and click Next.
Review the configuration summary, and click Next.
Select No, and click Next.
Before you can import from interface tables, you must create an interface table data definition. You create data interface table definitions in the Data Synchronization module in Performance Management Architect.
To create interface table definitions:
Log on to Performance Management Architect - Data Synchronization and select File > New > Data Interface Table Definition.
In the Data Interface Area Mapping Wizard, make the required selections and click Next.
For the interface area, select the interface table data source you created. Next, select the table and column that contains the values to import.
Select a column, enter a dimension name, and click Next.
Enter a name and description for the interface area definition, and click Finish.
Before importing dimensions into the Dimension Library, you must create and run a data synchronization or an import profile.
Data synchronization enables you to synchronize and map data between Hyperion applications, interface tables, and external files.
Profiles include important information about the dimensions to be imported such as new dimensions, whether to merge or replace existing dimensions, and dimension properties. You execute the profile to import dimensions into the Dimension Library.
"To import dimensions from interface tables:
In the Performance Management Architect Data Synchronization module, select File > New > Synchronization.
Select Hyperion Data Interface Area as the source type, and click Next.
Select a source data interface definition, and click Next..
Select an available destination application, and click Finish.
Drag a source dimension to a destination dimension to manually assign or change mappings.
Select File > Import > Create Profile to create an import profile in the Dimension Library
Enter the profile details and click OK. For Import Type, select Interface Tables as the Import Type.
Select Create dimensions for the non-mapped dimensions with the source dimension name, and click Next.
Review the mapping options, and click Finish.
When prompted to execute the profile, click Yes.
In this tutorial, you learned how to:
|Configure interface data sources|
|Create interface table definitions|
|Import dimensions for interface tables|
To learn more about Planning 9.3.1, refer to additional OBEs.
More Middleware Downloads