SUMMARY
This document outlines the reason for a cube size to be slightly bigger on the publishing node than on remote node(s) when the cube is published for the first time in Strategy 9.x.
SYMPTOM
In Strategy Intelligence Server 9.x, the cube size is slightly bigger on the node which initially publishes the cube as compared to the cube size seen on remote node(s) of the clustered environment. For example, the difference in size can be as small as 4KB.
CAUSE
This is working as designed. The size difference is because of the cube index generation on the publishing node. This index is not the cube lookup index and is a different index generated by the Strategy Analytical Engine (AE).
AE index is not persisted to disk, so when the cube gets loaded by the remote node(s), it has a slightly smaller size.
WORKAROUND
Unload the cube from memory on the node which initially publishes the cube and reload it again. When the cube is unloaded, the generated AE indexes are discarded.
