Forum Discussion

Rithik_Prem's avatar
Rithik_Prem
New Contributor III
2 years ago

Unable to process Cube View because of Nested Member Expansions

Hi,

While exporting the Cube View to PDF and Excel we are getting the below error,

Unable to process Cube View because of the Nested Member Expansions resulting in 167,125,564 rows and the maximum allowed is 1,000,000 rows. 

We have tried by enabling the Sparse Row Suppression still we are getting the same error. Is there any way to resolve this error?

Thank you.

  • Producing so many rows in a CubeView is inefficient, even if they get suppressed. You'll have to review your filters to land on something more sensible.

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    Producing so many rows in a CubeView is inefficient, even if they get suppressed. You'll have to review your filters to land on something more sensible.