Problem: When opening a canvas you get this error message: “The database did not respond in a timely fashion, you can try reloading the page, if the error persists please contact IT support.”
Solution: If IIS where the OLAP pump is set up doesn’t work you can get this error message.
But the most common explanation is normally MDX-queries that asks for something that not any longer exists in the cube. If you for example create gems using one data source (cube) and then later change to a slightly different cube you can run into this problem.
To solve the problem, check the MDX for the slicers/gems on the canvas one by one and see where you get the problem.