Partitioning can provide the following benefits:
For block storage databases, data synchronization across multiple databases
Essbase tracks changes made to data values in a partition and provides tools for updating the data values in related partitions.
Outline synchronization across multiple databases (except when an aggregate storage database is the target of a transparent partition)
Essbase tracks changes made to the outlines of partitioned databases and provides tools for updating related outlines.
Ability for user navigation between databases with differing dimensionality
When users drill across to the new database, they can drill down to more-detailed data.