Use External Analytics to export a group of entities as a star schema to relational databases, for use by other EPM System products. This enables you to leverage and maximize your data as follows:
You can use the robust and diverse reporting features available to EPM System models. Many EPM System products can report directly from the star schema data. See Reporting Utilities for Extended Analytics.
.
You can useOracle Essbase Integration Services reporting functionality from the star scheme database to transfer data to a multidimensional Essbase database that other EPM System products, such as Financial Reporting, can use to report. See Reporting Utilities for Extended Analytics.
You can also create a Strategic Finance reference database and copy the entities from multiple Strategic Finance databases for reporting to a central location. Because these entities are isolated, you can change the numbers in the financial models to analyze possibilities without affecting your production data. You can refresh referenced entities.