Options to improve performance when loading flat list used in reporting
I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module.
The reporting module needs to have 5 lists + time and also requires summary to be on so data can be reviewed at aggregate levels.
As a result the import action to load the flat list and data has poor performance.
Are there options to improve the load performance without giving up the requirements on the reporting module?
I was thinking about creating a staging module with summary turned off that uses sum function and then feeding that into the reporting module but that will add extra space.