Q: BWA Index compression issue...
We have a problem with our BWA and I would like to know if there is a good solution for it.
The basic problem is that we have an item-based cube, where we use exception aggregation for "number of headers". When a change is done to the data, we will get one row in the InfoCube with 0's only and one with the real values. Exception aggregation will then in some cases (depending on drill-down) count this header twice. This can be solved by compressing the InfoCube.
The problem with BWA is that even if we compress the infoCube, the BWA index is still not compressed, and the only solution we have found is to delete, create and fill the index again (which of course takes time and we would like to avoid doing this daily). We are not using BWA delta index for this Cube.
Has anyone experienced this before and do have any solution?
Thank you in advance,