Time to Complete

Topics

Viewing Screenshots

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.

Overview

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.

Scenario

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.