nlim,
Microstrategy has a pretty robust tool-set. High end OLAP is great; doesn't get overwhelmed by too many categories at any level of a dimension. However, I must say, I'm not a ROLAP supporter, generally speaking.
However, my only word of warning about Microstrategy is their...