Hyperion Analysis Studio is what I use

Google Hyperion Analysis Studio user's guide or tutorial. Then follow the link to do the tutorial.
I also use Oracle Es*****ase.
Not sure which industry you are in. I am sure the application softwares vary from industry to industry.