Need help in interpreting EPM trace file... method [WriteSmart] / [SetSmartFormula]

[rishabh_gupta]

Hi!

I am working with a customer for their SCM IBP application, which has an EPM addin based Excel Client.

While looking at the traces for this application, I saw a lot of time being spent on the method [SetSmartFormula] as below -

2015-04-07 14:32:35,055|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteSmart|SOPADMIN|||||1|Method [Write Smart] start#

2015-04-07 14:32:35,059|INFO|OfficeWrappers|FPMXLClient.Office.ExcelReportWriter.WriteSmart|SOPADMIN|||||1|The report000 owns 31260 DownAxis.ResultMembers#

2015-04-07 14:32:35,061|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.SmartLineSwitch|SOPADMIN|||||1|Method [Switching Excel Rows] start#

2015-04-07 14:32:35,063|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.SmartLineSwitch|SOPADMIN|||||1|Method [Switching Excel Rows] end, duration = 0.000 s#

2015-04-07 14:32:35,065|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.SmartColSwitch|SOPADMIN|||||1|Method [Switching Columns] start#

2015-04-07 14:32:35,068|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.SmartColSwitch|SOPADMIN|||||1|Method [Switching Columns] end, duration = 0.000 s#

2015-04-07 14:32:35,071|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteData|SOPADMIN|||||1|Method [WriteData] start#

2015-04-07 14:32:35,690|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteData|SOPADMIN|||||1|Method [WriteData] end, duration = 0.617 s#

2015-04-07 14:32:35,693|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteRows|SOPADMIN|||||1|Method [WriteRows] start#

2015-04-07 14:32:36,068|TRACE|Performance|FPMXLClient.Office.EPMExcelMultiRangeManager.SetSmartFormula|SOPADMIN|||||1|Measure [SetSmartFormula] start#

2015-04-07 14:33:29,482|TRACE|Performance|FPMXLClient.Office.EPMExcelMultiRangeManager.SetSmartFormula|SOPADMIN|||||1|Measure [SetSmartFormula] end, duration = 53.412 s#

2015-04-07 14:33:29,484|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteRows|SOPADMIN|||||1|Method [WriteRows] end, duration = 53.789 s#

2015-04-07 14:33:29,486|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteColumns|SOPADMIN|||||1|Method [WriteColumns] start#

2015-04-07 14:33:29,488|TRACE|Performance|FPMXLClient.Office.EPMExcelMultiRangeManager.SetSmartFormula|SOPADMIN|||||1|Measure [SetSmartFormula] start#

2015-04-07 14:33:29,489|INFO|ReportManagement|?.?|SOPADMIN|||||1|check if writting formulas is necessary in 0 ms#

2015-04-07 14:33:29,498|TRACE|Performance|FPMXLClient.Office.EPMExcelMultiRangeManager.SetSmartFormula|SOPADMIN|||||1|Measure [SetSmartFormula] end, duration = 0.009 s#

2015-04-07 14:33:29,500|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteColumns|SOPADMIN|||||1|Method [WriteColumns] end, duration = 0.012 s#

2015-04-07 14:33:29,515|INFO|OfficeWrappers|FPMXLClient.Office.ExcelReportWriter.WriteSmart|SOPADMIN|||||1|(Smart) Writting Time: 00:00:54.4574452#

2015-04-07 14:33:29,517|TRACE|Performance|FPMXLClient.Office.ExcelReportWriter.WriteSmart|SOPADMIN|||||1|Method [Write Smart] end, duration = 54.459 s#

Could you please help in understanding what this could mean?

Any documents which help in interpreting the trace file generated by EPM will be really helpful.

[chuan_ding]

Hi Rishabh

The trace you attached is EPM performance trace.
You can take a look at the following URLs which can help you understand what the trace means.
- http://wiki.scn.sap.com/wiki/display/CPM/EPM+Add-In+Logging
- http://scn.sap.com/community/epm/blog/2013/07/09/performance-analysis-and-optimization-for-bpc-10

Best regards,
Chuan