Maximum number of columns or rows on C4C reports

[former_member633515]

Hello,

I would like to know if there a recommendable maximum of columns or rows on C4C reports.

Thanks for your help.

[former_member497128 · Accepted solution]

Dear alarosaamiel.

Ideally we recommend to have not more than 50 fields (characteristics + key figures) but for maximum no of columns and rows, it always depends on data volume.
If reports runs for some time and then it fails then mostly it would be due to memory dump. It happens as report tries to fetch huge amount of data and we have limited memory.
Data(data volume) means data (no of records/rows, no of fields/columns, filter/selection used, descriptive fields) report contains as per run and we do not have fixed limit on the same.
It depends on how we are executing the report.
For example: Report with 1 million records and 20 fields might run but but same 1 million records with 30+fields might not run.
Report with 1 million records and 10 fields (mostly non descriptive fields) might run but but same 1 million records with 5 fields (all descriptive fields) might not run.

-> There are below ways to get rid of this issue:
1) Remodel the data source (if it is not standard). Reduce the number of joining conditions/fields. You can also check if we can use inner join instead of left outer join.
2) Reduce the no of records/data fetched via report in single run. This can be done in below ways: A) Apply some values in Selection to restrict report from fetching huge data. You can also use fixed value selection while editing/creating report.
B) Reduce the number of fields we are fetching in a single run. Fetch fields which are most relevant one. Also try to avoid descriptive fields as these fields will consume more memory.
3) Adding the fields while editing/creating report performs better as compared to adding fields via option "Add Fields" after creation of report.

For more details, please check the attached case document 2366796 - Best Practices for Modelling and Handling Data Sources and Reports - Performance.

Hope this helps.
Regards,
Saurav Kumar

[former_member633515 · Accepted solution]

Thanks Kumar for your help, it is exactly the info I needed!

Best Regards.