Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to get SQL query from MDX query

  1. #1
    Join Date
    Sep 2007
    Posts
    17

    Default How to get SQL query from MDX query

    Greetings!!!

    We are trying to obtain the SQL query for a particular virtual cube. We were only able to reach till the MDX query. This MDX query is nothing but the query specified in the jsp file that is used as the query parameter. Please let us know how this MDX query is changed to SQLand how are these queries executed on the database tables. It would be great if we could get some help regarding the entire logical flow of Mondrian.

    Thanks in Advance
    Sarath & Nisha

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    There's no simple answer to that question. A given MDX statement doesn't map 1:1 to a SQL statement. Read the architecture docs to understand more.

    Julian

  3. #3
    Join Date
    May 2006
    Posts
    104

    Default

    It might help to turn on tracing in the mondrian.properties with 'mondrian.trace.level=1', if not already set. This outputs the sql statments Mondrian uses for a particular MDX query on the console [window] and in JBoss' server.log.
    Ralph

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.