Maybe someone can help...
I've never tired to create OLAP cubes. This subject is absolutely new for me.
I see Pentaho offers some products to create such data layer; Schema Workbench, Mondrian server...

Suppose I have MySQL database. What I need to convert data into OLAP cubes, what layers I should organize with what tools? Pentaho Server is the only tool to display those data?
Can I use Pentaho Kettle to do some part of the job?

Any help appreciated,