Essbase Database Requirements

If you use an Essbase multidimensional database as an external data source, the database must meet these requirements:

Have a single dimension containing the members that correspond to measures used in Performance Scorecard, such as the Accounts dimension.
Have a single dimension containing the members corresponding to targets used in Scorecard, such as the Results.
The dimension in the database that corresponds to time must use one of these conventions:
- A single dimension
- Two dimensions: one dimension for intra-year periods, such as months or quarters, and one dimension for the years. Members corresponding to individual years must be placed at the leaves.
Place the results within the intersection of the dimensions, or have a member in the Values dimension that corresponds to results
Does not have time elements that are more frequent than daily.

Caution!

If the Performance Scorecard and Essbase servers are installed on different computers add the same ODBC system DSN to each computer.