Cube optimization/dimension re-ordering is only suitable for numeric-only cubes. If the cubes contain string data then the last dimension can't be changed and therefore there will be a minimal benefit as the last dimension is the most important by far for cube optimisation. Optimising dimensions in a cube structure does not change the actual order […]
