When you build a model, to ensure efficiency, it's important that you consider the model's size.
Note: Calculating a model's size is not an exact science. It depends on many factors including the object types, line item formats, and the number of dimensions and list items.
Object types and how much memory is accounted for
| Object | Amount (Bytes) | |||
| Empty | 1 char | 60 char | 1 million char | |
| Item name (e.g. list name) | false | 500 | 500 | false |
| Item code (e.g. list code) | 0 | 0 | 0 | false |
| No data formatted line item cell | 0 | false | false | false |
| Number formatted line item cell | 8 | 8 | 8 | false |
| Text formatted line item cell | 8 | 8 | 8 | 8 |
| Time period formatted line item cell | 4 | 4 | 4 | false |
| Date formatted line item cell | 4 | 4 | 4 | false |
| Boolean formatted line item cell | 1 | 1 | 1 | false |
| List formatted line item cell | 4 | 4 | 4 | false |
Line item subsets contain line items from the same or different modules in a model. If you want to manage the size of your model, use line item subsets to avoid line item duplication in other modules. To avoid further duplication, you can also use the COLLECT function to pull values into a target module from a source module.
Additionally, it's best practice to set your line item's summary method to None, and only use another summary method when you need it. This approach ensures that aggregated cells are only calculated when you require them.
You can also incorporate numbered lists to increase model efficiency. Use numbered lists to manage duplicate names in a model, avoiding empty cells.
It's also important to consider the number of dimensions in your model. For example, if a module contains more than five dimensions, you should split the module in two.
You can view the size of your module in the Cell Count column in Modules .
