Forum Discussion

KhanhNguyen's avatar
KhanhNguyen
New Contributor II
3 years ago

Cubeview: Maximum Row when export to Excel/PDF

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

 

Cube View
  • EricOsmanski's avatar
    EricOsmanski
    3 years ago

    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.

  • EricOsmanski's avatar
    EricOsmanski
    Valued Contributor
    3 years ago

    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's avatar
    KhanhNguyen
    New Contributor II
    3 years ago

    Hi Eric,

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

    Have a nice day

    Khanh