Deploy a mondrian schema in pentaho 5.1 without schema workbench

Question

I have a question, in pentaho 5.1, how can I deploy a cube without using the schema workbench? I'm kind of newbie in Pentaho. Is there a cmd line? Java code? Or something like... Thanks a lot!

Answer 1

You can do that in the User Console.

There is a menu Manage Data source... There you can upload your xml and refer to a database connection for it.

Answer 2

First, I suppose you have installed BA Server and have made at least fact table. In case you don't know what the fact table is, or someone else is reading this answer, you can find brief explanation here. Of course, it's better to have full Star Schema. You cannot create Snow Flake inside Pentaho User Console. You can create it with Pentaho Schema Workbench or by manually edit mondarian.xml.

Make sure that your JDBC driver is inside BA Server driver directory. Look! Open Pentaho User Console. It's by default at localhost:8080/pentaho or yourdomain.name:8080/pentaho and login as administrator

1. File -> New -> Data Source
2. Choose Data source
3. Type Choose fact table and define connections to dimensions (if exists)

4. Choose to modify cube on the end of data source wizard

   .