Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incremental Updates to Cubes

Status
Not open for further replies.

HarpreetSingh

Programmer
May 25, 2000
2
AE
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>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top