Share
Report
125Hello All;
When running the MultiDimensional Analysis - Account Analysis Detail Report it can often take a very long time.
Other times with the same exact setting it is relatively quick.
Also, sometimes it takes so long it actually crashes Dynamics GP
Having ran profiler and gathered a bunch of information I created some clustered/non-clustered indexes and some statistics
After this the report ran quickly a time or two but then resumed its slowness
I do have a scheduled task to rebuild/reorganize indexes and such
Does anyone else run this report and have this issue?
Thanks
Ian
*This post is locked for comments
All responses (
Answers (
