Has any one else experienced very long build times for very large databases? It makes sense that the database’s size is correlated with the build time, but our build times are starting to become unbearably long (and sometimes don’t finish building by the start of the business day, leading to issues in meetings.) Our build times just keep getting larger as the database grows, too. We’ve gone from 3 hours to 5 hours in short order.
Is there a way to fix this or get around it? We’ve already taken our summarizing way down (we had had it set at 300 days, but this proved to be one major cause of our long build times.)
Are there other ways to shorten build times that don’t involve sacrificing data (and preferably not dimensions or properties either?) I may be asking for a miracle.
Also, what are the leading causes of long build times?