Speed Up Your Essbase: Optimizing Database and Calculation Settings
As Oracle Essbase has grown in popularity over the years, customers have pushed the envelope on dimensionality and quantity of data. With cubes containing more data and expected to crunch increasingly complex calculations, the update process (outline refreshes, data loads and calculations) can sometimes get bogged down.
Optimizing Essbase might seem like sorcery if you’re unfamiliar with the inner workings of the software, but it’s not so mysterious if you understand the basics and know where to look for opportunities. In other posts, we discussed some ideas for optimizing Block Storage (BSO) Essbase updates related to model design (Outlines and Calc Script basics) and data management. (more…)