[Mondrian] <join>,<Query> and <view> for snowflake schemas

[Selina Tech]

Dear All:

    When I study the Mondrian schema. I think we have three different ways
for the Dimension of snowflake schema.

Way 1:  Use <Join> as the example at
http://mondrian.pentaho.com/head/documentation/schema.php#Star_schemas

Way 2: Use <Query> to define a ‘table’, and use this ‘table’ for Dimension
table

Way 3. Use <View>  to define a view ‘table’ by <SQL> and use this ‘table’
for Dimension table

     Is any one of them wrong? if they are right, how could I choose one of
them? How is the different on performance?  when we use <view>, is this
<view> will generated in memory, disk or database? what happen if the
result of view is huge on size?


Your any help is highly appreciated.

Sincerely,
Selina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160318/830c59ec/attachment.html