# [Mondrian] Problem Using Dimension Twice

Matt Campbell mcampbell at pentaho.com
Tue May 5 08:53:17 EDT 2015

```I have a vague memory of there being an M4 issue similar to that, but couldn't find a logged bug.  Tried it out myself and added a role playing dimension for Time, then crossjoined Time and Time2.  That worked for me.

Can you post the relevant schema snippets?

-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Isaias Sanchez
Sent: Tuesday, May 05, 2015 8:40 AM
To: mondrian at pentaho.org
Subject: Re: [Mondrian] Problem Using Dimension Twice

I am using Mondrian 4.0 (w/ saiku 3.1 standalone).

And yes, I am using two dimensions using same source but different foreign keys into fact table.

Exactly what's explained in the book Mondrian in Action, section 5.1.4.

Matt Campbell wrote on 05/05/15 14:26:
> What version of Mondrian are you running?  And do you mean you've added two DimensionUsages based off the same source?  Just tried a simple crossjoin of 2 usages of the Time dim w/ Foodmart using Mondrian 3.9, that worked for me.
>
>
> -----Original Message-----
> From: mondrian-bounces at pentaho.org
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Isaias Sanchez
> Sent: Tuesday, May 05, 2015 6:25 AM
> To: Mondrian ML
> Subject: [Mondrian] Problem Using Dimension Twice
>
> Hi,
>
> When I use a dimension twice (or more) in a cube, I can display one of them in rows and another in column, but I can't display both dimension together in Row field.
>
> I get this exception:
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Tuple contains more than one member of hierarchy ...
>
> I am just arriving to the list so probably you have talked about that before.
>
> Cheers,
>
> Isaias S.
> _______________________________________________
> 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
>

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
```