Illustrates the term data sparsity

Question

Illustrates the term data sparsity and how this effect upon aggregation?

Answer 1

Data sparsity is term specified for how much data we have for an exact dimension/entity of the model.

This affects aggregation depending upon how deep the combination of members of the sparse dimension make up. When the combination is lots and those combinations do not have any accurate data then creating space to store those aggregations will be a waste like a result, the database will become vast.