Worksheet Generation Error: Error in Refresh Sheet

[Former Member]

Hi All, can someone please help me with the below worksheet generation error.

I can able to generate more than 40 sheets by using Worksheet generation but it throwing me an error "Error in Refresh sheet" while Generating worksheets more than 40 entities and there is no error message while generating for less than 40 members.

The details of error message is "Report identifier"

The workbook and sheet is not protected and we used epm formatting sheet for Hierarchy level formatting for level one members and Dimension member\level formatting for two local members.

SAP BPC NW 10.0 SP11

[Former Member · Accepted solution]

Hello Gogula,

Please note the following copy paste from SAP Note 2249501 - ALL: Worksheet Generation create broken worksheet 
(not released to customer yet, still in "For Checking" status)

"The worksheet Generation use the excel sheet copy process to generate the
good number of sheet  and each epm sheet contains many Items inside.
When Excel executes many sheet copies in the same process, excel memory generate
errors, and the only workaround is to close the workbook and reopen it.
Or this workaround is not a possible behavior in the worksheet generation.
The limitation appears after some worksheet copy, in our use case we detected this
around 24 copies, but this number depends of the complexity of the sheet
copied. the behavior after problem appears is, broken sheets, with interface problems and reports are not known. The best way to solve this problem is to use office x64. Office x64 seems to manage better the memory around this issue."

Please note that this issue is scheduled to be fixed in EPM add-in 10.0 SP25.

Best regards,

Nedra.

[Former Member · Accepted solution]

Hi Nedra, Thank you for your reply. Could you also let me know where we can find up to how how much memory I can use for excel sheet generation and capability of my system. The resource monitor in task manager is giving some results of consumption and availability of ram but it is not accurate. because even though I have 600 mb of free ram the excel is unable to generate sheets which has memory size of less than 200 mb. so I would like to know the exact consumption and break point for the work sheets generation and please help me with this thank you.