You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

RESTRUCTUREHEADS not working as expected during defragmentation

edited Aug 2, 2018 2:36AM in Essbase 15 comments

Summary

RESTRUCTUREHEADS not working as expected during defragmentation

Content

Hi All,

 

We have a planning cube, and we carry out the defragmentation activity by adding a dense dimension member and then deploying it. This process usually takes a very long process but ultimately, brings the average clustering ratio closer to the ideal value of '1'.

To improve the timings we introduced RESTRUCTUREHEADS 8, in the essbase.cfg file.

Now the restructuring time is almost halved, but there is hardly any change in the average clustering ratio.

So, are we using RESTRUCTUREHEADS correctly, or are multiple threads creating fragmentations in DB of their own ??

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!