RESTRUCTUREHEADS not working as expected during defragmentation
SummaryRESTRUCTUREHEADS not working as expected during defragmentation
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 ??