Latest News / Articles
New Perth Head Office
Our growth over the last 12 months has finally caught up with us. After months of overcrowding...
more »
Come and see M-Power present at Insync10
Steve and Barry have been selected to present at this years Insync10 event, the topic - One an...
more »
Oracle Announce the Release of new Hyperion EPM Solution
We are all very excited here at M-Power, yes we’re that sad, to finally get our hands on the l...
more »
Upcoming Events
- no events atm
Essbase – Run Length Encoding (RLE) Compression
What is This?
When Essbase stores blocks to disk, it can compress the blocks using one of three different methods. Used appropriately the correct compression option can significantly aid performance.
RLE compression is one of the 3 available options. It is recommended for Planning databases. This is because it's typical to find the same data values duplicated across months, see screen shot below.
What Does it Do?
Taking the sales figure above, the default behavior is to separately store the $100 value for Jan, Feb, Mar etc. With RLE compression, the $100 is stored only once with a reference that it is duplicated x times. Across 12 months this can reduce database size by a factor of 6.
How to Set it Up?
RLE compression is enabled via Essbase Administration Services. Clients should consult with your M-Power consultant prior to setting this up.
Selected Clients
Downloads
Latest downloads added:
Newsletters
These are the following newsletters:
Subscribe to our newsletters: