#82 how to user the drillThrough in olap4j or mondrian


Hi Julian,
I want to user the mdx to drillThrough the data,then I get the error mondrian.olap.DrillThrough cannot be cast to mondrian.olap.Query
mdx string like the "DRILLTHROUGH MAXROWS 5 select {[Measures].[CallNum]} ON COLUMNS,([Model].[Model].Members) ON ROWS from [Call_Record]"
is mondrian Support DRILLTHROUGH NOW?

today I user the cell.drillThrough() to drillThrough the data,but I don't kown how to control
the the return column.

Could you give me a simple Example to let me kown how to user the olap4j or mondrian to drillThrough the data.

Forgive my poor English.


  • Julian Hyde

    Julian Hyde - 2013-04-24

    Can you attach the full call stack? What version of Mondrian?

    • LLoyd

      LLoyd - 2013-04-25

      The version of Mondrian is mondrian-
      The full call stack in the lucBoudreau's Reply.
      With his help I can user DRILLTHROUGH in olap4j,but I don't know how to control the return column.

      Last edit: LLoyd 2013-04-25
  • Luc Boudreau

    Luc Boudreau - 2013-04-25

    Mondrian 3.2 did not support the RETURN clause. You have to use 3.4+.

    • LLoyd

      LLoyd - 2013-04-26

      Thanks for your help and patience!
      The RETURN clause is useful in 3.5.
      Is there API of Drillthrough?
      I don't find something about Drillthrough in the mondrian's documentation.


      Last edit: LLoyd 2013-04-26
  • Luc Boudreau

    Luc Boudreau - 2013-10-03
    • status: open --> closed
  • Luc Boudreau

    Luc Boudreau - 2013-10-03

    The current way to perform drillthrough only works on Mondrian by calling olapConnection.createStatement().executeQuery

    For XMLA support, there is a separate ticket created in this tracker.


Log in to post a comment.