Hi,

Question : Can Pentaho Meta editor support a non-star schema model?

Scenario:

We are trying to evaluate pentaho to embed as a BI tool for our DW product. Our datawarehouse is not a typical star scheme model in which dimensions are directly linked to facts;but we have group-bridge tables between dimenion and facts

A typical join between DIM_PRODUCT& FACT_CASE looks like:
DIM_PRODUCT.PRODUCT_ID = PRODUCT_BRIDGE.PRODUCT_ID and
PRODUCT_BRIDGE.PRODUCT_GROUP_ID = PRODUCT_GROUP.PRODUCT_GROUP_ID
PRODUCT_GROUP.PRODUCT_GROUP_ID = FACT_CASE.PRODUCT_GROUP_ID

You can notice above the addtional joins in our model between dimension and facts. I had build this relationship in Pentaho meta editor and then created a business view of DIM_PRODUCT & FACT_CASE table in it. When I tried to pull a adhoc report from these two tables;it says invalid relationship.(Note: I didnt bring the Group & Bridge tables in business view;since user does need to view the intermediate tables)

Currently we use SAP BO that supports this as we are planning to move to pentaho for cost-effectiveness.Please provide clarity on whether the above is achievable in pentaho.

Thanks,
Sreedev.