The execution of report Default report failed_Maximum number of Rows and columns

[manohar_pappireddy]

Hi,

We are on SAPKW73010,SAPK-80010INCPMBPC,

EPM10,SP14.

There is a report with 56 columns and 380 rows.When the report is refreshed getting the error message

"The execution of report Default report failed.Please contact your administrator" after a long time.

I have full access.It is not related to security issue.I modified the report to pull the data for 1 column and is workig fine.Even when I tried to refresh the report with less rows working fine.

Is there any limitation on number of rows and columns for an EPM report?

One more intresting thing..I have recreated the same report in other enivrionment(In production we have 3 environments) where data is very less.In that environment report is retrieving the data.

NB: I can't use  "Remove Empty", Rows and Columns as the report has lot of excel formulas.

Thanks,

Manohar

[former_member186338]

"There is a report with 56 columns and 380 rows." and without filters and without "Remove Empty", Rows and Columns? Not so big, has to execute normally!

Do you have a lot of dimension member formulas and not standard measures?

Vadim

[manohar_pappireddy]

Hi Vadim,

There are no other dimension member formulas.

We are using custom measure.

Thanks,

Manohar

[manohar_pappireddy]

Hi Vadim,

Refreshed the report with Standard measure and retrieval is very quick.

Thanks,

Manohar

[former_member186338]

Then your issue is with custom measures. Incorrectly created - can be extremely slow!

Vadim

[manohar_pappireddy]

The custom measure has lot of calculations.User accepted to split his report into 3 parts and issue is closed now.

[former_member186338]

Ok, then close the discussion. At least the reason is found. But it's better to improve custom measure if possible!