This tutorial covers exporting data with Extended Analytics and creating templates of export settings.
Approximately 20 minutes.
This tutorial covers the following topics:
|Exporting Data with Extended Analytics|
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 exporting data with Extended Analytics. Extended Analytics enables you to export data and metadata from Financial Management applications to a relational database. The data and metadata are exported in a star schema format. Each star schema consists of a fact table and a number of dimension tables. Each record in the fact table of the star schema represents a cell or dimension intersection in the Financial Management data structure.
After exporting the data, you use Essbase Integration Services to transfer data from the relational database to Essbase Analytics databases or other relational reporting products for further analysis and to run reports.
Your Connecticut sales office wants to analyze its January 2008 software sales to Fortune 500 companies. You are to use Extended Analytics to export the data to a relational database where the data can be further analyzed. You must also create a template for the export settings to enable the sales office to use the settings in the future.
Before starting this tutorial, you should:
Have access to or have installed Oracle® Hyperion Financial Management, Fusion Edition 22.214.171.124.0
Have access to or have created a Financial Management application (The Training application is used for this tutorial)
|3.||Have created a separate database for storing data|
|4.||Have set up a data source name (DSN) for the database|
|5.||Have configured the DSN with Oracle's Hyperion EPM System Configurator|
In this part of the tutorial, you use Extended Analytics to export data to a relational database.
On your desktop, perform the following actions:
a. Double-click the Workspace icon.
b. Enter user name trnadmin and password hyperion.
c. Click Log On to log on to Workspace.
Select Navigate > Applications > Consolidation > TRAINING.
The Training application is displayed.
In the Browser View pane, select Tasks > Consolidation Administration > Extended Analytics.
The Extended Analytics page is displayed.
In the Point of View section, click Scenario.
The Point of View page is displayed.
Perform the following actions:
a. Select the following POV:
b. Click OK.
Under Options, perform the following actions:
a. In the Destination Database (DSN) list, select the data source name for the target database.
b. In the Relational Table Prefix box, enter a prefix of up to 10 characters for the database table name.
Note: The default prefix is the name of the application.
c. In the Extract Format list, select the format for the star schema.
d. Select Exclude Dynamic Accounts to exclude data for dynamic accounts.
e. Click Create Star Schema.
f. Optional: To export data to an existing star schema, click Update Star Schema.
In the Running Tasks window, confirm that the process was completed successfully.
Tables for the star schema are created in the target database.
You then use Integration Services to transfer data from the relational tables to Essbase Analytics databases or other reporting products.
After exporting the data to a target database, you create a template that enables you to save the settings. You then select the template in the Template list to retrieve the export settings.
On the Extended Analytics page, click the Save template as icon.
The Save Template for Extended Analytics page is displayed.
In the box, enter Connecticut, and click Save.
Verify that the template name is displayed in the Template list.
In this tutorial, you learned how to:
|Export data with Extended Analytics|
To learn more about Financial Management, refer to additional OBEs.
More Middleware Downloads