#82 how to user the drillThrough in olap4j or mondrian

olap4j-1.1
closed
Julian Hyde
None
1
2013-10-03
2013-04-24
LLoyd
No

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.

Discussion

  • 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-3.2.1.13885.
      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.

      http://mondrian.pentaho.com/documentation/configuration.php#Properties

       
      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.