US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: How to generate SQL statement with ANSI Join Clause

  1. #1
    Join Date
    Jun 2013
    Posts
    4

    Default How to generate SQL statement with ANSI Join Clause

    When the join happens between a cube and dimension tables, Mondrian will generate the SQL like this: "SELECT ..... FROM .... WHERE fact_table.column = dimension_table.column".
    How can I generate SQL statements with ANSI Join style? like "SELECT .... FROM fact_table JOIN dimension_table ON fact_table.column = dimension_table.column"

    I didn't find any options from Dialect Interface. There's a method called "allowsJoinOn" in Dialect Interface, but I didn't see it guarantee using ANSI Join syntax (JOIN...ON) on the Join happens between fact table and dimension tables. Maybe the allowJoinOn() can only work for Join among dimension tables, when the <Join> tag defined in Mondrian schema..



    Any one see this problem?

  2. #2
    Join Date
    Jan 2013
    Posts
    490

    Default

    I believe allowsJoinOn is disabled on all dialects in current versions of Mondrian. There were some issues with it (http://jira.pentaho.com/browse/MONDRIAN-934).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •