Often there are "blank" elements within a cube or the result of a cube query that produces empty rows and/or columns. The application therefore provides a convenient mechanism to hide empty rows and /or columns in several places:
The Query ribbon tab
|Report Context Menu|
|The Selection Panel|
The simple example below highlights the effect. Notice that the "Components" row in the first grid is automatically removed in the second.
This functionality does NOT remove rows or columns that have values in them. This includes rows or columns that have "zero". Often, with cube formatting, cells with zero value appear to be blank, but do have, in effect, a value. In this situation, the row or column will NOT be hidden.
Further, the ENTIRE row or column must obviously be blank or empty to be removed.