I have a cube which has already data(millions of records - historical data) loaded into it. The queries based on this cube are running very slow. I found out that the size of some dimensions are more than 40% of the fact.
I want to make those dimensions Cardinal. Now, if I check the high cardinality check box and activate the Infocube, will it effect the existing data in the cube?
Do I need to drop all the data in the Cube, make the dimensions Cardinal and reload the data again?