Just got it solved. It is actually one of the dimension "Proactive Caching" was set to Automatic MOLAP instead of MOLAP. After I made the changes the MDX query runs through.