FCCS Hybrid Cube Report runs in seconds, when before as a FR report run for 20 minutes.
We recently migrated an FCCS application from legacy to enterprise. Once in enterprise license we activated the dense sparse optimization. Amazingly enough, the total amount of database size was reduced from 50 Gb to 4GB.
We have a financial report in this new environment that takes forever to open approximately 20 minutes, also in the legacy one it takes the same amount of time to open.
I migrated this report in the new enterprise FCCS Reports module, and runs in seconds.
Can someone please explain this dramatic change in performance?