Working with hidden cells: NON HIDDEN keyword

You can use the NON HIDDEN keyword to hide tuples of a set that do not have any readable cells. Empty cells are still included.

Example

SELECT
   {[Measures].Members} ON COLUMNS,
   NON HIDDEN {[PRODUCTS].[Total Servers].Children} ON ROWS
FROM [TotSales]
WHERE ([YEARS].[2017])