Hyperion Essbase (MOSC)

MOSC Banner

RLE Data Compression

edited Dec 29, 2017 3:49PM in Hyperion Essbase (MOSC) 6 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center