Incremental Updates to Cubes

[HarpreetSingh]

Hi!<br><br>I have 1 fact table (called BalSheet) in which, I have put a one character field called 'UploadStatus'. Whenever I add records to the fact table, I set the value of this field as 'I' to denote new records. My Cube name is 'Balance Sheet'. Now when i wish to upload Incrementally update the data, I say <br><br>&quot;BalSheet&quot;.&quot;UploadStatus&quot; = 'I' and press the finish button, it comes up with following error messages when processing the cube : <br><br>OLAP Server Error : File error (during Open operation) 'Access is denied'<br><br>Error ( 207) : Internal Error (Server initializing Partition '~BALANCE SHEET_update' (final))<br><br>Error ( 207) : Internal Error (Unexpected internal error (Partition '~BALANCE SHEET_update'))<br><br>Rolling Back transaction in database 'SCBDW'<br><br>then, it rolls back the transaction.<br><br>Can anyone help<br><br><br>To solve the problem, i selected the PROCESS cube option which worked. However, this is not a solution to the problem. Could you help?<br><br>Thanks.<br><br>[Harry Singh]<br>