Compression request taking long time

[Former Member]

Hi All

I have started a compression for a request in to my cube having 84 million records. The job is runiinig now more than2 days,

Is it normal to take this time for this much numbet of records.

I am not sure weather i should cancel this job . Let me know if i can check somewhr , How much time it will take more or the job is not working anymore.

Thanks

DD

[Former Member]

aa

[former_member213240]

Hi,

You have to cancel this job because it should not take so much time. Validate if any request of the cube is in yellow or any requests in reconstruction tab. Also check if there is any scarcity of the system resources to run then batch process.

Regards

DInesh

[Former Member]

HI Dinesh

My cube is gettting data daily. Anyways i am doing the compressionon the reuest which is alread green , Does that make adiffernce .

Thanks

DD

[former_member213240]

Hi,

As the requests are loaded daily,the data volume will be huge. Then initially, the best way is to compress a finite number (10 - 20 requests) of the total requests manually.

Select 10th or 20th request no in the collapse tab and compress in background. Once it is successful, then continue for next 20 requests and so on.

Later include the compress process step in the process chain to automate the process.

Regards

Dinesh