Place the cursor over this icon to load and view all the screenshots for this tutorial.
(Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor
over an individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking it.
Overview
This tutorial covers creating interface tables and importing data and metadata from interface tables.
Your company wants to import data and metadata from an external source (Excel file or GL file) into the Reports application and dimension library, respectively. To do this, you create an interface table data source. After creating the interface table data source, you use a SQL program to extract the required data and metadata from the external source into the interface table. Next, you create an interface table definition and synchronization to import data from the interface table into the Reports application. Finally, you create and execute a profile to import metadata into the dimension library.
In this part of the tutorial, you create and configure an interface table in the Hyperion Configuration Utility.You configure the interface table by creating data source links that are used during data synchronization and profile creation.
1.
Navigate to Start > Programs > Hyperion > Foundation Services > Configuration Utility, and click Next.
2.
Select Enterprise Performance Management Architect 9.3.1.0.0 and, in the expanded list, select Interface Datasource Configuration. Click Next.
3.
Enter the following information for Hyperion Shared Services, and click Next.
Property
Value
Server
<servername>(<servername> is the name of your Shared Services server.)
Port
58080
User
admin
Password
password
4.
Select Create a new datasource link, and click Next.
5.
Select Microsoft SQL Server 2000, and click Next.
6.
Perform the following actions:
a) Enter the following property values for the interface datasource:
Property
Value
Datasource Name
FM Datasource
Server
<servername>(<servername> is the name of your Shared Services server.)
Port
1433
Database
Interface
User
AppsAdmin
Password
hyperion
b. Select Create Interface tables:
c. Click Next.
7.
Click Yes to delete all existing tables.
8.
Click Next.
9.
Verify that the interface datasource configuration has succeeded, and click Next.
10.
Select No, and click Next.
11.
Click Finish to exit the configuration utility.
You can now use any SQL load program or data transfer tool to extract data from the external source into the interface table.
After extracting data from the external source to the interface table, you create synchronizations to import data from the interface table into the Reports application. Before you create synchronizations, you create an interface area that defines the data interface table. You create the interface area and synchronization in the Data Synchronization module of Enterprise Performance Management Architect.
Bookmark
