Skip to Content

Noncumulative Cube Copy for Inventory IC where compression is not possible

Dear All

We have got Month (0RT_C37) and Week (0RT_C36) Inventory Infocubes. Compression has never been done on any of this cube. The data is fine and result is coming correct but output is very slow. We have done the initialization on this cube on mid of 2008. We have to copy the entire cube to a ZCube and do the compression performed on that Zcube. Our system is BW7.3 SP Level11 and we are going to upgrade to 7.4 . We tried to move the marker values(RECORDTP=1) to the Zcube with DTP setting (Initial Non-cumulative for Non-cumulative values) which is not happening. But other values with movements we are able to move. The only OSS note found to address this issue is1426533 which is not relevant for us. Is there any workaround for the situation where no compression is ever happened on the cube and the compression is impossible due to some issues, hence we want to copy the entire data to another Zcube and perform the compression there.

Regards

Reshoi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Feb 16, 2015 at 12:12 PM

    Dear Sander

    I tried with the solution which I was mentioning and got the result properly. I have run delta also on top of that and the result is correct. Only Issue I got is with the cardinality table correction which was solved through an OSS note. Could you please let me know how we can minimize the downtime if we are going to implement the inventory flow from the scratch also the implementation of the DSO for the movements. Currently we have modified the standard Infocube with an additional characteristic for Movement Types. Is there any standard DSO available for the movement types.

    Regards

    Reshoi R

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Reshoi,

      Theoretically speaking you could simulate a 2LIS_03_BX stock initialization with marker update using BW data. However, I never have seen such an approach in practice. I advise you to be very careful with any "non-standard" approach.

      Anyway, it's an interesting idea. If you would go for such a scenario, please keep us informed !!

      Best regards,

      Sander

  • Feb 09, 2015 at 09:40 PM

    Hi Reshoi,

    Inventory InfoCubes must be compressed to guarantee query performance. Why did it never happen in the past? What are the issues which make compression impossible?

    Please give a bit more background information to understand your situation better and why compression should not be possible.

    Thanks,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Reshoi,

      Thank you for your detailed information. I understand that you have a very special case.

      Please test such an approach very carefully. I hope it will work out well.

      Alternatively, did you consider to build up Inventory Management from scratch? There are ways to minimize the downtime and it would give you the opportunity to improve the data model and data flow. E.g. I recommend to add a Goods Movements DSO into the data flow.

      Best regards,

      Sander

  • Feb 11, 2015 at 05:54 AM

    Dear Sander

    I have successfully performed a backup using a single article to another Zcube and the data seems to be correct. I will perform the same with more articles and see if it is going right. If so then I will come to the conclusion that what I am currently doing the solution for this.

    Regards

    Reshoi R

    Add comment
    10|10000 characters needed characters exceeded