[Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember

Paul Stoellberger p.stoellberger at gmail.com
Thu May 12 21:18:30 EDT 2011


I just found the source of my problem.
It only shows up in combination with Measures.Employee Salary for me.

A closer look to FoodMart.xml:
<CalculatedMember name="Employee Salary" dimension="Measures"
      formatString="Currency"
      formula="([Employees].currentmember.datamember, [Measures].[Org Salary])"/>


Julian, is that formula still valid? (The same foodmart is in the mondrian perforce)
If yes, then it wouldn't be a bug...

I tried to reproduce Erik's issue but I dont have the time to setup foodmart xmla .. and it works fine on MondrianOlap4j

Filed a bug for the other issue in my former mail: http://jira.pentaho.com/browse/MONDRIAN-941

-Paul

On May 12, 2011, at 16:43 , Julian Hyde wrote:

> Seems to be a duplicate of one of the bug mentioned by Paul S. in April:
>  
> http://lists.pentaho.org/pipermail/mondrian/2011-April/003211.html
>  
> I don't know if there is a workaround. It needs to be fixed.
>  
> Paul,
>  
> Can you log the bugs please. (Sorry I didn't reply to your email at the time.)
>  
> Julian
> 
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of VanIngen, Erik (FIPS)
> Sent: Thursday, May 12, 2011 4:37 AM
> To: Mondrian developer mailing list
> Subject: RE: [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember
> 
> Thanks for thinking along with me. My guess is that is a bug in the Mondrian XML/A Servlet and that is it related to the use of Members. However with other clients I am not able to reproduce the problem. This could suggest that the problem relies in the Olap4j driver for XML/A.
>  
> The problem remains. What could be the solution for this error?
>  
>  
>  
>  
>  
>  
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Paul Stoellberger
> Sent: 12 May 2011 10:35
> To: Mondrian developer mailing list
> Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to RolapCubeMember
>  
> I think that there are some problems when the Members of a Level are selected. So its probably related.
>  
> Occasionally I see something like this as well (olap4j trunk + mondrian trunk):
>  
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
>   NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee Salary]}) ON ROWS
> from [HR]
> .....
> Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot be cast to mondrian.mdx.MemberExpr
>         at mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoinArgFactory.java:222)
>         at mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArgFactory.java:157)
>  
>  
>  
>  
>  
> On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:
> 
> 
> Dear Mondrian,
>  
> This mdx
> SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
> over Olap4j Xmla gives this error
> Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
>  
> Configuration is Olap4j version: 1.0.0.445,  Mondrian: mondrian-3.2.1.13885-embedded,  Db: Postgres.  
>  
> What could be the solution for this error?
>  
> Regards,
> Erik
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>  
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110513/38a46efc/attachment.html 


More information about the Mondrian mailing list