How To Speed Up Your Essbase Database Restructure

In Essbase 11.1.2.2, Oracle added a configuration option to improve the performance of Essbase Block Storage database restructures.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

RESTRUCTURETHREADS is a setting you can add to your Essbase.cfg file to enable parallel restructure of BSO databases. The proper syntax taken from the Essbase Technical Reference is:

RESTRUCTURETHREADS [ appname [ dbname] ] n

Application and database are optional parameters and if omitted will apply to all BSO databases on the server. n specifies the number of threads to use for parallel processing the restructure.

I have seen tremendous improvements to dense restructures on systems with the horsepower to support this. I usually set the number of threads to half the total number of processor cores on the Essbase server. For example, if an Essbase server has four quad-core CPUs, I will set this to 8. I leave off the application and database when I have control over when the restructures will occur.