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

    Default How to get SQL query from MDX query


    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


    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.


  3. #3
    Join Date
    May 2006


    It might help to turn on tracing in the 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.

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.