Is there a way to create a Cube in Mondrian Pentaho without a Star Schema? I tried to create a Cube with non-start schema, but I cannot export the Schema file for that and cannot customize the Dimensions.
More precisely I want to define multiple fact tables.
In Mondrian the Cube definition only defines one Table. So all your facts has to come from this single table.
To include facts from different tables you need to use a database view. Either a native view in your database or a Mondrian View.
I experienced massive performance differences between using a native view and a Mondrian View, because of how Mondrian structures it's SQL queries. I recommend native database views.