RLE Data Compression
Hello,
I tried changing the Data Compression of an Essbase database, that is, Edit Properties, Storage Tab, Data Compression drop down, from Bitmap to RLE.
I did a level zero export, cleared the data, changed the data compression from Bitmap to RLE, imported the data, and ran the following calc all script.
//ESS_LOCALE English_UnitedStates.Latin1@Binary
SET UPDATECALC OFF;
SET AGGMISSG ON;
SET EMPTYMEMBERSETS ON;
CALC ALL;
The last time I ran this script, on Aug 24, 2017, it took one minute. Yesterday, it took 6 hours before it failed because the server ran out of disk space.
Before the changes, the database had 8 pag files and 1 ind file. By the time the Calc All failed, there were 38 pag files and 3 ind files.