Array size for optimal workbook performance

Hello,

Good Morning!!!

Measure database with <2GB array size is OARCLE recommendation but I found that 30% of database measures in assortment planning are reaching greater than 2GB array size for our ongoing project. I am not sure if we can go ahead and execute some test exercises.We tried splitting the departments to bring down the array size and we ended with 1000+ local domains.

Any techniques to handle this?

Thanks!!