Use of empty cells

Cell
When you use MDX numeric functions such as AVG, Count, and so on, empty cells are usually ignored! The only exception is the Count function. It provides a includeempty
parameter to indicate whether to include empty cells.
1:non Empty keyword
Generally used at the axis level.
Select
{[Measures]. [Store Sales]} On columns,
NON EMPTY {[time2].[ All Time2]. [1997]. [Q4]. [10].children} on Rows
From Sales
Show October 1997 daily Non-empty sales.
The no non EMPTY keyword displays all sales.
2:count
October Sales Day count (whether or not sales)
With member [Time2]. [Sales Day] as ' count ([time2].[ All Time2]. [1997]. [Q4]. [10].children) '
Select
{[Measures]. [Store Sales]} On columns,
{[time2]. [Sales Day]} On Rows
From Sales

October Sales day count (including sales date only)
With member [Time2]. [Sales Day] as ' count ([time2].[ All Time2]. [1997]. [Q4]. [10].children,
Excludeempty) '
Functions such as 3:sum and AVG
These functions are ignored for empty cells. (Do not convert to 0)