Pentaho Community Forums - Metadata http://forums.pentaho.com/ Pentaho Metadata Editor, MQL, Publishing... en Thu, 20 Jun 2013 10:24:21 GMT vBulletin 60 http://forums.pentaho.com/images/misc/rss.png Pentaho Community Forums - Metadata http://forums.pentaho.com/ Creating relationship on a non-star schema model http://forums.pentaho.com/showthread.php?144312-Creating-relationship-on-a-non-star-schema-model&goto=newpost Fri, 14 Jun 2013 13:26:34 GMT 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... 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. ]]> Metadata ssreedev http://forums.pentaho.com/showthread.php?144312-Creating-relationship-on-a-non-star-schema-model Problem using Date mask http://forums.pentaho.com/showthread.php?143465-Problem-using-Date-mask&goto=newpost Thu, 30 May 2013 09:43:34 GMT Hello,

I'm currently trying to get my data according to a specific format for my date column.

I tried to follow some topics saying that I should add a new "concept" in the concept editor and then add a property of "Mask for Number or Date" and finally applying it to my column.

Once done, when I get into the query editor, no changes appear, does anyone already get this issue ?

Thanks all ]]> Metadata pentaUser http://forums.pentaho.com/showthread.php?143465-Problem-using-Date-mask