Not restricted Microsoft Analysis Services functionalities slow performance speed

What ever is not restricted causes hedeaches. It is the love and hate story with Microsoft Analysis Services software. Despite all advantages, level of disadavntages is also significant.

Here is the idea,

…more users are using OLAP cubes within Excel, different cubes per different sheets, more calculations have to be made. Amount of calculations grow tremendously with many new users attacking production serevrs. Using OLAP cubes with data from Data Warehouse is excellent feature becuse power of two very powerful solutions are combined with ease.

And after a while Analysis Services OLAP works very very slowly.

Poor performance is solved with service restart on server. Performance is immidiately back to normal, bu problem with restarting services is that they need to be resterted often. I would rather say, too too often.