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.