Symptom
SAP BW Precalculation failed.
Precalculation Server log "BExPrecalcLog.txt" ends with entry like following:
-> Trying to open "C:\Program Files (x86)\Common Files\SAP Shared\BW\BExAnalyzer.xla"
-> Enter semaphore for BExAnalyzer addin
-> BExExcelPrecDll.ExcelApp: CreateObject for Excel.Application called.
Broadcasting Log in transaction RSRD_LOG shows:
Untreated exception on the precalculation server
System.Runtime.InteropServices.COMException (0x800 0A03EC): Unable to get the Open property of the Wo
kbooks class
at Microsoft.VisualBasic.CompilerServices.LateB Binding.LateGet(Object o, Type objType,
, Object[] args, String[] paramnames, Boolean[] Co
pyBack)
at Microsoft.VisualBasic.CompilerServices.NewLa ateBinding.LateGet(Object Instance, Typ
ng MemberName, Object[] Arguments, String[] Argument
The precalculation works in Console Mode.
Read more...
Environment
-
SAP Netweaver BW Release Independent
-
SAP BW Precalculation Release Independent
Product
Keywords
Precalculation, Unable to get the Open property of the Workbooks class , KBA , BW-BEX-ET-BC-PREC , Precalculation Server / Export of Workbooks , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.