Report taking more time for execution

[Former Member]

Hi Vadim,

I have opened a new discussion as per your suggestion.

I am facing a performance issue with the report ,which is taking too much time for execution(6 mins to 10 mins).i am using this report for a long time, i didn't get any issue earlier and the report execution takes within(3 secs to 10 secs) based on data records.

I am using a BPC version

The trace shows that UJF_FILE_SERVICE_UI has the performance issue.I found a sap note1874034 on this,which suggests patch upgradation(SP2 to SP3).Would I need to check anything else before going to this upgradation. No new enhancements has done in the report.

Thanks,

Pavan

[Former Member]

Hi Pavan,

Run lite optimise package in BPC and see if refresh time improves.

Andy

[damovand]

Hello,

I recommend upgrading to the latest version to get all performance improvements.  You can find all the information regarding pre-requisites and version from the central release note.

Best Regards,

Leila

[former_member186338]

Anyway, please answer the questions:

1. Not default measures used

2. Dimension member formulas used

3. Number of cells read

4. Multiple members in page axis

5. Do you have isuues with one report or all reports?

Not sure that UJFS performance has some relation to the report performance...

But please talk to your basis team to check server performance in general...

Vadim

[former_member186338]

P.S. And one year old SP04 is ready for installation