Some screenshot may help me in future
Add a new datasource
configure new mysql connection
Add a new datasource wizard
Select your external DB
Select fact table as Mondrian star structure requires (Basically you will build Mondrian schema)
Map facts table to dimension tables
Save it
If you want edit mode then choose “Customize model now”
Go and create a new Saiku Analytics
Set columns and rows
Now you can enjoy your nice graphs
