Before you generate Essbase databases, perform these tasks:
Ensure that theOracle Essbase Integration Services server is running on the same computer as your application database server.
Start the Essbase OLAP server is running.
Start the Essbase OLAP client is running on the application database server.
Locate the directory to house the Integration Services XML files. These files define the structure of the Essbase database that is created.
Load the Integration Services console to create a catalog.
Set up a connection to the Scorecard database.
Set up an ODBC connection to the database that houses the Integration Services metadata catalog.
Set up an ODBC connection to the Performance Scorecard database.
Note: | If the Performance Scorecard and Essbase servers are on separate machines, create identical ODBC connections on both servers. |
Set all spaces on the database schema to be auto-expandable to ensure there is sufficient space to accommodate data being transferred.
Ensure the dimensions, dimension members, databases, aliases, and targets names do not contain illegal characters. See the Oracle Hyperion Performance Scorecard User Guide.