Compression not necessary; no requests found for compressing ?

[former_member263043]

Hi experts,

I'm working on BI7.

I've got a cube with several requests to compress.

When I try to compress, I get the following message

"Compression not necessary; no requests found for compressing"

This does not seem to be true to me.

Does any one know the points that are checked ?

Thanks for your help

Best regards

Stephane

[former_member266938]

This message was moderated.

[alessandro_gandelli]

Hi,

yes it can.

Try looking at the kba:

1584120 - RSM1489 Compression not necessary; no requests found for compressing

bye,

[Former Member]

Hi,

Please check the following:

1 - Cube contains requests to be compressed.

2 - Check the compression setting, if it's through process chain. If the setting, for eg, is for compressing requests older than 7 days and all requests older than 7 days are already compressed then compession will obviously not happen, until any new requests come.

3 - If any request for previous days is red in the Cube manage. if yes than make it red and delete it if it's a FULL load. Retry compression.

Hope this helps.

Edited by: Deebanshu Mukarjee on Nov 17, 2008 10:01 PM

[Former Member]

SE16 > RSMDATASTATE .

Give the input as your cube name and select F8.

INFOCUBE ==> Your Cube Name

DMEXIST ===> Must be 0 (No values must be here )

DMALL ===> Must be 0 (No values must be here )

If DMALL and DMEXIST fields have values, they need to be reset.

Only then can we compress.

Regards,

UD

[Former Member]

>

> SE16 > RSMDATASTATE .
> 
> Give the input as your cube name and select F8.
> 
> INFOCUBE ==> Your Cube Name
> DMEXIST ===> Must be 0 (No values must be here )
> DMALL ===> Must be 0 (No values must be here )
> 
> 
> If DMALL and DMEXIST fields have values, they need to be reset.
> Only then can we compress.
> 
> Regards,
> 
> UD

How can we reset DMALL and DMEXIST??

Best regards!

Ivan

[Former Member]

Hi,

Please check in listcube transaction whether the cube has data. It is possible that the request ids might be there in manage screen and the data might have been deleted using selective deletion.

Regards,

Pramod

[former_member263043]

Hello,

I've already checked this and data is still in the cube in F table with the request id

The table containing the last compressed data indicates a lower number of last compressed request.

Best regards

Stephane