A partitioned application can span multiple servers, processors, or computers.
You can achieve significant calculation performance improvements by partitioning applications and running separate calculations on each partition. When using partitioning:
Evaluate the performance impact on the overall database calculation. To improve performance, you can:
Redesign the overall calculation to avoid referencing remote values that are in a transparent partition in a remote database.
Replicate a value in the database that contains the applicable formula.
For example, if replicating quarterly data for the Eastern region, replicate only the values for Qtr1, Qtr2, Qtr3, and Qtr4, and calculate the parent Year values locally.
Ensure that a referenced value is up-to-date when Essbase retrieves it. Choose one of the options previously discussed (redesign, dynamically calculate, or replicate) or calculate the referenced database before calculating the formula.
See Designing Partitioned Applications and Creating and Maintaining Partitions.