Skip to Content
author's profile photo Former Member
Former Member

Compression function is not working in process chain for Inventory ?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

11 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 04:53 AM

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

    Issue is solved.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2012 at 12:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2012 at 07:30 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2012 at 07:32 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2012 at 10:32 AM

    Hi Asit,

    Try to manually compress the cube.

    Can u post what error you got while compression??

    Regards.

    Harish.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2012 at 06:01 AM

    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


    2.JPG (12.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • 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

      1.jpg (6.8 kB)
  • Posted on May 21, 2012 at 12:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2012 at 01:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 22, 2012 at 03:33 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 23, 2012 at 04:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.