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

Movements from Inventory management, AR - compression

Hello,

We have the Init and deltas in the infocube (movements - 2lis_03_bf). We are loading and using only the movements and NOT stock initialization (2lis_03_BX) or revaluations (2lis_03_UM) . Now it is required to compress the data in movements Infocube because of volume of data in F fact table and performance reasons. I have gone through couple of SDN forums and 'How to... inventory management' related to this, mostly likely it is talking about the the combination of stock(bx) and movements(bf).

Since we are using only the movements(BF), how the compression execution should be, either the 'No marker update' enabled or disabled? What are preventive things needs to be taken care before compression. How the data will be validated after compression to make sure the data is correct without any inconsistancies.

Account Receivables Infocube holds non-cummulative keyfigure with 'NCum. value with NCum value change'. Here too, the same question as either 'No marker update' enabled or disabled during compression.

Thanks

Sree

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2008 at 05:58 PM

    Hello all,

    Please let me know if you need any additional details. I'm looking forward to receive the response.

    Thanks

    Sree

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 09:20 AM

    Sreedh.

    I think the reason that you need not the BX data source to setup the initial stock is your initial stock is equal to 0. it means your initial stock has already included in material movement document.

    This has already meantioned in "how to ... Handle Inventory.." doc.

    My proposal to compress the data is to disable the "NO marker update" option. it means you use marker update.

    Hope it helps

    Alex.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 02:44 PM

    Alex.... Thanks for your response, i will compress the data with 'NO marker update' disabled.

    Can anyone respond as the AR also compress with 'NO marker update' disabled.

    Thanks

    Sreedh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 09:42 AM

    Hi,

    After you compress your InfoCube, Please update the result to us. Let's know It's correct or not

    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.