Unable to process Cube View because of Nested Member Expansions

[Rithik_Prem]

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.

[JackLacava · Accepted solution]

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.