For compression of data no need to drop INDEX. You can directly compress the cube.
But make sure before loading or deleting the data from Cube you need to drop the index and after completion of loading or deletion you need to re built the INDEX
Hope this will help you
Last Wiki Answer Submitted: October 12, 2012 10:08 am by aakashg35 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
For compression of data no need to drop INDEX. You can directly compress the cube.
But make sure before loading or deleting the data from Cube you need to drop the index and after completion of loading or deletion you need to re built the INDEX
For compression of data no need to drop INDEX. You can directly compress the cube.
But make sure before loading or deleting the data from Cube you need to drop the index and after completion of loading or deletion you need to re built the INDEX
Hope this will help you