Reduce the size of empty row

[Ranvir06]

Dear community, we have requirement to reduce the size of empty row, do we have any solutions to this. Any solutions to this question will be very helpful.

Thank You!

[NicolasArgente]

Hey @Ranvir06 !
Have a look at the row data settings in your cube view.
Please use the suppress option with care as it might impact the performance of your cube view.

Please give a kudo if it helps.

[Sridhar_M]

you might be using same member name for all empty rows (ex: A#None), if that is the case, I would try applying cell format on the row with condition like below

if RowE1memberName = None Then "Select your formatting" End If

If above logic works, create a literal parameter and paste that code in the parameter value.

Where ever you need that formatting for empty rows just use that parameter in cell format. 

Regards

Sridhar 

[CarlosAlvear]

Dear all,

Do you have an idea to answer to the original question about the row size?

Thank you. BR