info cube compression

[Former Member]

hello

I do not understand the generation of the P-index on the E fact table after compression of an inventory cube, my basic purpose of compression is to save storage space but the P-index is very large and it has doubled the storage space, can someone tell me how to resolve this issue? The impact when dropping this index?

thanks

[colm_boyle · Accepted solution]

Hi Akrem,

unfortunately compression retains the aggregated format of the data. I would recommend following the note below to reduce the number of requests stored in your admin tables...

Running RSSM_REDUCE_REQUESTLIST...

1431315 - P24: Reduction of very large request lists in cubes and DSOs

Thanks,

Colm

[Former Member · Accepted solution]

Hi Colm,

I did not understand ,could you please explain more

thanks