[Mondrian] Drillthrough: org.olap4j.OlapException: Cannot do DrillThrough operation on the cell
mcampbell at pentaho.com
Mon Nov 16 11:46:00 EST 2015
There are a couple issues with your query- Drillthrough should select a single cell from a cube. You have sets of members on COLUMNS and PAGES, so the DRILLTHROUGH is incorrectly being applied to more than one cell.
I don’t think that’s the cause of your error, though--I just ran a quick test with Foodmart and was surprised to find that a Drillthrough on more than one cell doesn’t result in an error. It appears to just silently use one of the cells involved. Mondrian should probably give a nice error in such cases (consistent with SSAS).
Your query also uses a calculated measure, which is also not allowed for drillthrough.
I’d try changing your query to be a single cell with a base measure in context and see if that will run successfully.
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Manuel Aristaran
Sent: Saturday, November 14, 2015 10:05 PM
To: mondrian at pentaho.org
Subject: [Mondrian] Drillthrough: org.olap4j.OlapException: Cannot do DrillThrough operation on the cell
I'm trying to run a DRILLTHROUGH query on my cube but I'm getting an exception:
org.olap4j.OlapException: Cannot do DrillThrough operation on the cell mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(mondrian/olap4j/MondrianOlap4jStatement.java:107) mondrian.olap4j.MondrianOlap4jStatement.executeQuery(mondrian/olap4j/MondrianOlap4jStatement.java:65)
The query is rather simple:
select NON EMPTY [Jurisdicciones].[Jurisdiccion].Members ON COLUMNS,
NON EMPTY [Measures].[Vigente] ON ROWS,
NON EMPTY [Fecha].[Year].Members ON PAGES
The schema can be found here: https://gist.github.com/jazzido/62f1d20986360b9d7c42
Any help would be greatly appreciated, I’ve been scrathing by head about this for a couple days.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian