Adding blank row/Column

Mustafa_A
Contributor II

Is there a way to add a blank row/column within Cube View? I know it can be done, but can't seem to remember the code. I believe it was "|!Blank|"....

 

Thank you!

4 REPLIES 4

ChristianW
Valued Contributor

There is no blank row command, I always use (or add) A#None to the pov to get an empty row. |!Blank!| is a parameter with all the formatting option to give background and font the same color (white, transparent or any other color). You can create the parameter on your own, or you can download a predefined set of formatting parameter from the market place.

Hey Christian,

I also use this syntax, but have a quick view with row suppression on.  Is there a way to cheat in a blank row with suppression on?  I can't seem to solution one and saw this post.  Have you come across this before?

Hi Christian, 

I used your solution of A#None, however, is there a way to get rid of the dimension icon on the left in order to have a fully blank line?

Thanks, 

JohnMorehead
New Contributor III

I second what Christian said, put in an intersection that you know will never have data, like A#None, and it will always come back blank.