Skip to Content

EPM 10 Report refresh takes too long

Hello, we have a report that doesnt have that much dynamic formating and no comments, but still when we try to pull about 1000 rows of data, it just takes about 4 minutes to refresh. is that normal? thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 05:00 AM

    Hi Manny,

    Do you have lot of dimension formula?

    4 minutes is too long for only 1000 rows of data. How many columns do you have in the template?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2012 at 05:01 AM

    Hi Manny,

    Even a report with millions of records should not take 4 mins to refresh. This is definitely unusual and there is something problematic for sure in your report.

    Does it happen with other reports/input schedules also? Have you tried opening the same report from other machines also? Try out these checks which should give some more idea as to if this is the problem across all systems/reports, etc.

    Hope it helps!!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2012 at 10:18 AM

    Hi Manny,

    I agree with Nilanjan about dimension formulas. But the worst case is the combination of dimension formulas and MEASURE not equal to default cube measure.

    B.R. Vadim

    Add a comment
    10|10000 characters needed characters exceeded

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.