Forum Discussion

MattRussell's avatar
MattRussell
New Contributor
2 years ago

Supress NoData Rows across entire Cube View (All Rows)

I have a cube view that utilizes a shared Row and Column set.

The row set has roughly 300 rows.

Is there a way to Supress NoData Rows across the entire cube view - as opposed to modifying the setting row-by-row?

Thanks,

Matt

  • JakeSteinberg's avatar
    JakeSteinberg
    New Contributor III

    Hello,

    I would first suggest using member expansion functions where possible to limit the number of rows you manually create. If that cannot be done, then row suppression can only be modified on a row-to-row basis.

    To expedite modifying 300 separate rows you can extract the row set through the Load/Extract page and perform a find and replace on the necessary Cube View properties (highlighted in the picture below). Make sure to set the necessary properties from False to True.