on 01-08-2008 8:19 PM
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
Hi,
After you compress your InfoCube, Please update the result to us. Let's know It's correct or not
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello all,
Please let me know if you need any additional details. I'm looking forward to receive the response.
Thanks
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.