This is the process by which we delete the request IDS which leads to space savings. All the regular REQUESTS are stored in the F table. When you COMPRESS, the request ID is deleted and data is moved from the F table to the E table. This saves space and IMPROVES performance but the disadvantage is that you cannot delete the compressed requests INDIVIDUALLY. You can, however, still use SELECTIVE deletion.

If you are using noncumulative key figures in a cube, the cube should be compressed as often possible to improve performance.

This is the process by which we delete the request IDS which leads to space savings. All the regular requests are stored in the F table. When you compress, the request ID is deleted and data is moved from the F table to the E table. This saves space and improves performance but the disadvantage is that you cannot delete the compressed requests individually. You can, however, still use selective deletion.

If you are using noncumulative key figures in a cube, the cube should be compressed as often possible to improve performance.