[Mondrian] Apache Kylin and mondrian
julianhyde at gmail.com
Mon May 23 23:57:35 EDT 2016
Are you using Mondrian version 3 or 4? Mondrian 4 supports composite keys. Define a composite primary key for the dimension table, and include multiple columns in the ForeignKeyLink.
See http://mondrian.pentaho.com/head/documentation/schema.php#Measures <http://mondrian.pentaho.com/head/documentation/schema.php#Measures>, towards the end of the section.
Neither version of Mondrian supports left join. Can you describe what you hope would happen? If a record in the “sales" fact table has a “productId” value that doesn’t exist in the “product" table, would you expect that that fact to be counted against a “null” member of the [Product] hierarchy? Each hierarchy has a null member, but the system removes them from axes. So you’d need a user-defined “other” member.
> On May 23, 2016, at 7:21 PM, Jian Zhong <zhongjian at apache.org> wrote:
> Hi all,
> I'm a developer of apache kylin.
> I'm trying to write a tool generate mondrian schema for Apache Kylin cubes.
> As I know, mondrian does not support left join, and for composite key.
> If two tables join with more than one column,it seems not well supported.
> I'm blocked on how to define multiple columns join for tables.
> Could anyone give me some guide?
> Best Regards!
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian