Skip to main content
M
MattRussell
Newcomer
November 28, 2023

Supress NoData Rows across entire Cube View (All Rows)

  • November 28, 2023
  • 1 reply
  • 0 views

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

1 reply

J
JakeSteinberg
Contributor
November 28, 2023

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.

 

JakeSteinberg_0-1701208522887.png

 

    Terms & ConditionsAccessibility statement