Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: getting java result set or sql query

  1. #1
    Join Date
    Jun 2003
    Posts
    12

    Default getting java result set or sql query

    What command can I use to get the JAVA result set sent to mondrian? I want to capture the raw sql? Is there a way to do this? thanks, -T

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

    Default RE: getting java result set or sql query

    A Mondrian result is usually made up of several SQL statements; and some of the results may come from the cache populated by earlier SQL statements. So there isn't a unique 'result set' which we could return.
    There is a method 'String mondrian.olap.Cell.getDrillThroughSQL'. Applied to a particular cell object, it returns a SQL statement to retrieve all of the fact table rows which contributed to that cell's total.
    Is that what you're looking for?

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.