Skip to Content
author's profile photo Former Member
Former Member

EPM workbook limits

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Mar 10, 2014 at 03:39 PM

    Just try 😉

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2016 at 03:25 AM

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



    • You cannot have more than 20 EPM Add-in reports in a single Excel sheet.
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2016 at 11:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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 😊

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.