About Sparse and Dense Dimensions

Sparse dimensions lack data values for the majority of member combinations. Dense dimensions have data values for the majority of member combinations. At least one dense dimension is required. Custom attributes can't be assigned to dense dimensions. The application designates the Account and Period dimensions as dense, and the remaining dimensions as sparse. To optimize performance for sparse dimensions, the application searches for and calculates only occupied data values in each dimension combination, reducing calculation time and disk usage. You can modify these settings.