Cube Cells

A cube is composed of cells, organized by measure groups and dimensions.

Leaf Cells
  A leaf member has no child members, hierarchically speaking, and typically references a single record in a dimension table. This kind of cell is referred to as a leaf cell.

Nonleaf Cells 
  A nonleaf member is a member that has one or more child members. In this case, the value of the cell is typically derived from the aggregation of child members associated with the nonleaf member.

Empty Cells
  There can be intersections in a cube that have no data. These intersections, called empty cells, frequently occur in cubes because not every intersection of a dimension attribute with a measure within a cube contains a corresponding record in a fact table.The ratio of empty cells in a cube to the total number of cells in a cube is frequently referred to as the sparsity of a cube.