Hi everyone,
I hope you’re all doing well! I’m reaching out to see if anyone has experience optimizing planning analytics models for large datasets. I’m currently struggling with performance bottlenecks—specifically, long query response times and high memory usage when processing over 10 million rows.
If you have insights or best practices—such as index design, aggregation strategies, or configuration tweaks—I’d greatly appreciate hearing them. I’ve already tried limiting dimensions and using incremental refreshes, but the model still feels sluggish during peak usage.
Many thanks in advance for any advice you can share!