Pentaho and Saiku

Some screenshot may help me in future

Add a new datasource

pentaho_mysql_jdbc

 

 

configure new mysql connection

pentaho_mysql_connection2

 

Add a new datasource wizard

pentaho_datasource_wizard

 

pentaho_datasource_wizard2

 

Select your external DB

pentaho_source_wizard3

 

 

Select fact table as Mondrian star structure requires (Basically you will build Mondrian schema) 

pentaho_ds_wizard_fact_table

 

 

Map facts table to dimension tables

pentaho_ds_wizard_map2 pentaho_ds_wizard_map1

Save it

pentaho_datasource_wizard_save

If you want edit mode then choose “Customize model now”

pentaho_ds_wiz_cust_model

 

Go and create a new Saiku Analytics

pentaho_saiku_cube

 

Set columns and rows

pentaho_saiku2

 

Now you can enjoy your nice graphs

pentaho_saiku_graph4 pentaho_saiku_graph3 pentaho_saiku_graph2 pentaho_saiku_graph1