EPM workbook limits

[Former Member]

I need to generate EPM reports using 'Worksheet generation' option. Under a parent entity group, there are nearly 750 entities; for which in a single workbook, I need to generate worksheets.

How many worksheets can a workbook hold or can get generated for?

Is there any BPC limitation for maximum number sheets per workbook?

[former_member186338 · Accepted solution]

Just try

Vadim

[Former Member]

Hi,

Has anyone tried using the standard worksheet generation method?

I need to generate a workbook for 25 entities but Excel crashes when I try to do so.

Thanks,

Varsha

[former_member186338]

Just tested and successfully created workbook with 53 EPM sheets.

It depends on the sheet complexity etc...

P.S. Even 227 simple EPM worksheets

[Former Member]

Thanks for the reply Vadim. Could you please let me know which EPM patch were you on while trying this?

[former_member186338]

EPM SP24 Patch 1 Net 4 Big Vol

MS Office 2016, 32 bit, Windows 10 64 bit

Please test with very simple report....

Vadim

[Former Member]

Hi Vadim,

I tested a very simple report and could generate 35 worksheets. Maybe more will be possible but I gave only 35 entities in selection.

The structure of our report is as follows:

1. 2 reports in each sheet

2. Members exclusions

3. Have used copy Range function

Unfortunately I could not find any Note related to this which I can show to client.

Thanks,

Varsha

[former_member186338]

Sorry, but it's strange to think that there is a note that can explain the relation between report complexity and number of reports that can be generated using worksheet generation

It's not possible to measure report "complexity"!

Just try to simplify your report...

P.S.Even without EPM it's possible to create very complex Excel file that will crash

[Former Member]

Please see the note :  1763572 - EPM Add-in Limitations

• You cannot have more than 20 EPM Add-in reports in a single Excel sheet.

[former_member186338]

20 is a limit for the single sheet, the topic author is asking about multiple worksheets in the workbook!

[Former Member]

Sorry, I misunderstood the topic author .
And I try it, found the maximum number worksheets in the workbook is 24.  Is the result correct? or is it depend my desktop machine ?

The below picture is VBA Code:

[former_member186338]

First of all try standard EPM worksheet generation without any VBA!

And open a new discussion!