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:
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. |