CODEWITHSUNDEEP
pentahoolapmondrian
István
István

Reputation: 5127

Mondrian non-star schema, multiple fact tables

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.

Upvotes: 2

Views: 881

Answers (1)

bolav
bolav

Reputation: 6998

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.

Upvotes: 1

Related Questions