Cells which are sparse (i.e. not populated) are not handled any differently that populated cells, the model treats all cells as if they will be populated either by input or formula.
Quick question...Can the system determine the Sparse cells and optimize the models every time data is saved so that sparse cells don't occupy the space?
The maximum size of a single workspace is limited to 130Gb. Therefore, it would not be possible to create a single model that exceeds 130Gb. Instead, you would need to build multiple models within multiple workspaces to accomplish this.
Maximum workspace size is controlled by the infrastructure that the Anaplan platform operates. Any one Workspace does not exceed 130Gb. Within a 130Gb workspace an individual model could consume the entire Workspace. Note that model performance is effected by variables such as data volumes, concurrent users, calculation complexity and other factors of model design in addition to model size. These variables need to be considered along with the model size. Model size is generally estimated based on the number of cells within a model at a ratio of approximately 10 bytes per cell. Hence a model is limited to a range of 10-12 billion cells in order to fit within a single workspace.
Please feel free to reach out to your Customer Success representative to discuss your organization's options and goals.