If you are only looking for reporting tools, BIRT is totally free.
If you are looking for ETL tools, Oracle ODI, GoldenGate, Infomatica take up most of the market share.
If you are looking for multi-dimensional database, Oracle Essbase is the best, but pretty costly.
If you are looking for data mining tools, I guess SAS or SPSS are the best.
If you are looking for a beautiful and flexible front end presentation tool, there're many many choices.