Skip to Content
0

SAP BPC EPM SP 24 Patch 1 report refresh error (c0040203)

Apr 14, 2017 at 05:42 AM

91

avatar image
Former Member

Hello experts,

I have a system related error in only one client machine. when the a BPC report is run it gets struck at VBA code. The same report runs well in other machines by other people. The machine with the problem is run on EPM SP 24 patch 1.Net 4.0.

As shown above the report after making selections and refresh is getting updated values using vb code in other systems but this particular system shows error in vb code as shown.

The excel version used is standard 2010 sp1 32 bit version.

please find the vb code below

***************************************************************************************************

Function AFTER_Refresh()

Dim s1, s2, s3, s4, s5 As String
Dim total As Integer
Dim client As New EPMAddInAutomation

'Balance sheet Reconciliation calculation
s1 = client.GetDataTopLeftCell(Sheet6, "000")
s2 = client.GetDataBottomRightCell(Sheet6, "000")

s3 = "I" + Right(s1, 3) + ":I" + Right(s2, 3)
s4 = "M" + Right(s1, 3) + ":M" + Right(s2, 3)
s5 = "P" + Right(s1, 3) + ":P" + Right(s2, 3)

Sheet6.Cells(130, 10) = (WorksheetFunction.SumIf(Range(s3), "AST", Range(s4)) - WorksheetFunction.SumIf(Range(s3), "LEQ", Range(s4)) + (WorksheetFunction.SumIf(Range(s3), "AST", Range(s5)) - WorksheetFunction.SumIf(Range(s3), "LEQ", Range(s5))))

'P&L Reconciliation calcuation
s1 = client.GetDataTopLeftCell(Sheet6, "003")
s2 = client.GetDataBottomRightCell(Sheet6, "003")

s3 = "I" + Right(s1, 3) + ":I" + Right(s2, 3)
s4 = "M" + Right(s1, 3) + ":M" + Right(s2, 3)
s5 = "P" + Right(s1, 3) + ":P" + Right(s2, 3)
Sheet6.Cells(131, 10) = (WorksheetFunction.SumIf(Range(s3), "INC", Range(s4)) - WorksheetFunction.SumIf(Range(s3), "EXP", Range(s4)) - WorksheetFunction.SumIf(Range(s3), "AST", Range(s4))) + (WorksheetFunction.SumIf(Range(s3), "INC", Range(s5)) - WorksheetFunction.SumIf(Range(s3), "EXP", Range(s5)) - WorksheetFunction.SumIf(Range(s3), "AST", Range(s5)))

End Function

***************************************************************************************************

Thanking you

Praveen

iepzw.png (144.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 14, 2017 at 07:29 AM
0

Try to debug it yourself!

Write the procedure not related to After_refresh... test it

Share
10 |10000 characters needed characters left characters exceeded