Use Formulas on Partitions

A partitioned Essbase application can span multiple service instances. You can use formulas in partitioning, just as you use formulas on your local database. If a formula you use in one cube references a value from another, Essbase must retrieve the data during calculation.

Ensure that the referenced values are up-to-date, and carefully consider the performance impact on the overall database calculation.

With transparent partitions, carefully consider how you use formulas on the data target.

See Also

Use Calculation Scripts on Partitions

Transparent Partitions and Member Formulas

Performance Considerations for Transparent Partitions