Skip to Content
0
Former Member
Dec 02, 2005 at 08:19 AM

Cardinality Question

22 Views

Hi..

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?

Regards,

Sai.