[Mondrian] Drillthrough: org.olap4j.OlapException: Cannot do DrillThrough operation on the cell

Manuel Aristaran manuel at jazzido.com
Sat Nov 14 22:05:17 EST 2015


Hi,

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:

DRILLTHROUGH
select NON EMPTY [Jurisdicciones].[Jurisdiccion].Members ON COLUMNS,
  NON EMPTY [Measures].[Vigente] ON ROWS,
  NON EMPTY [Fecha].[Year].Members ON PAGES
from [dataset_ejecucion_gastos_bahia_user_bahia]

The schema can be found here: https://gist.github.com/jazzido/62f1d20986360b9d7c42 <https://gist.github.com/jazzido/62f1d20986360b9d7c42>

Any help would be greatly appreciated, I’ve been scrathing by head about this for a couple days.

Thanks!

--
Manuel Aristarán
jazzido.com <http://jazzido.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20151114/3bc50496/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 801 bytes
Desc: Message signed with OpenPGP using GPGMail
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20151114/3bc50496/attachment.bin 


More information about the Mondrian mailing list