Compression function is not working in process chain for Inventory ?

[former_member356574]

Dear Experts,

Compression function is not working in process chain for Inventory ?

• Process chain failed for 2 weeks to  load the data in to   Inventory Cube.
• After  2 weeks again reschedule  the Process chain .
• Data is loading  to cube request by request but request are not compressed.

      Plz  suggest !!!!!

Regards,

Asit

[former_member356574 · Accepted solution]

Thanks to u all !!!!!!!!!!

  Issue is solved.

[Former Member · Accepted solution]

Can you post the solution?  In case someone else has the same issue.  That's one question less 🙂

[former_member356574 · Accepted solution]

Hi ,

Compress the request manually & in  process chain created a new variant for Compression .

[former_member356574]

Dear All,

Plz  find the Process chain screen shot for Inventory .

Regards,

Asit

[former_member188080]

Hi Asit,

1.Try deleting the aggregates and do the compression and then try to recreate the aggregates..

2. take a look at OSS Note 217397

3. check cube in RSRV and see if there is any inconsistency for this cube..

4.check if previous compression/last compression job finished successfully,,if not what are the errors

5. check SLG1 log for job

6. check for ST22 if there is any dump

Thanks and regards

Kiran

[former_member209032]

Hi,

  Whether your cube is a source for other infoproviders? If so unless u move the data to furthur infoproviders you cannot compress the request. Please check your dataflow and reply back.

Regards,

Raghavendra.

[former_member356574]

Dear All,

 

 

     This is the setting   for the  Collapse variant in the process chain .

•   For this Collapse variant message is compression not necessary ,no requests.

Thanks,

Asit

[Former Member]

This variant will look for a request which is loaded the day before the compression.

So if you want to compress everything, put the xxx days to 0.

Or you do have a lot of requests which meet the condition?

[former_member186082]

Hi Asit,

Compression running today will compress yesterday's request. Check if there is TICK mark under compression status

Is this PC running bi-weekly? Do you have any process step of Drop Infocube before loading? In that case, compression won't work because there will be only one request of the present load

Regards

Chandu

[Former Member]

Hi Asit,

Please try the steps mentioned in the above posts.

Also right click and cross check if the correct cube (inventory cube) is added to compression variant.

(This should not be the issue. but in case by mistake wrong cube was added)

Thanks,

Vinod

[former_member356574]

Dear All,

• Data is  loading to Inventory cube by Process chain.
• In Process chain compression variant is available for compression.
• Data is loaded successfully with  Request  Status is Green

              No error Message .

Regards,

Asit

[Former Member]

Yes but what happens when you compress the cube:

1. manually?

2. via process chain?

3. if it does not work with any of these two, what does the compression log say

[former_member186082]

What are the settings maintained in variant?

Based on the conditions maintained, compression will be performed.

Is the compression starting? What does the job log say?

[former_member186082]

Hi Asit,

As said by friends, post the error message you get while compression.

Few possibilities are memory issues and count overflow due to huge data. If there is any dump, paste dump message here

Regards
Chandu

[Former Member]

Hi Asit,

Try to manually compress the cube.

Can u post what error you got while compression??

Regards.

Harish.

[Former Member]

Hi Asit,

Do you have a step to compress request in same process chain which loads data to cube?

or are you using a separate process chain that compress cubes?

Also did you try to manually compress the request of inventory cube?

Thanks,

Vinod

[Former Member]

Do you get any error message?  Compression is a DB-intensive operation, it could be that the temp space is not big enough.