• Without more details, I can only tell you to do less work on the SSRS.

    How long does it take to run the MDX?