I'd throw in excel power pivot over SSAS cubes. It fills In some of the gaps you described.