Dear All,
I am using analysis by dimensions for my inventory reporting, and using a Montly compression format.
The analysis is updated daily.
The case is:
One item was having transactions till 28th July.
On 31st July, when the analysis view was updated, the inventory was correct.
On 2nd, 3rd and 4th august, some transactions were posted for 31st July in the system.
The analysis was also updated daily.
But today, I found out difference in inventory for the item. When I checked, the ANalysis view was not updated for the entries of July which were posted in august.
The entries of august are properly compressed and updated.
Now, I am stucked as to-
1. how it happened?
2. How to update the view, as the problem is that the database is having more than 20 lacs entries, which will take more that 5 hours to get updated again if if start afresh.
Your help is appreciated.
Regards,
Deep
India
0
Comments
I was using the automatic update nightly in the job scheduler, but I turn it off at month end for a few day to allow for the few stray entries to be posted and then run the update after I am sure the months activity is done.
Thanks.
Deep
India