CODEWITHSUNDEEP
pentahocubemondrianfact
Akira
Akira

Reputation: 47

How to add multiple fact tables in a single mondrian cube in pentaho?

Need to associate multiple fact tables with a mondrian cube. The schema workbench doesn't allow to do so. How can we achieve this?

Upvotes: 3

Views: 1460

Answers (1)

Nikhil
Nikhil

Reputation: 621

You cannot add multiple fact tables in a cube. Schema workbench expects you to have a Star schema in which there will just be one fact table. If you need to combine information from two fact tables on the same subject but with different or same granularity, then you must create a virtual cube. It is easy and very convenient. You can refer to the following documentation:

https://help.pentaho.com/Documentation/6.0/0N0/020/040/000

Upvotes: 2

Related Questions