Cubeview: Maximum Row when export to Excel/PDF

[KhanhNguyen]

Hi,

I am working on a huge report (via Cubeview) with over 3 million rows with data, and i am unable to export to Excel nor PDF.

Error message siad that the maximum row allowed is 1 million rows.

Does anybody have an idea to increase the number of rows please?

Thank you very much

Khanh

[EricOsmanski · Accepted solution]

Do you have Sparse Row Suppression on?

Otherwise, there is a App Config setting that would need to be updated called "Max Number of Expanded CV Rows". Right now, it appears that is at 1MM.

[KhanhNguyen]

Hi Eric,

Thank you very much for your help. I do as your advice and it works so well 🙂

Have a nice day

Khanh