[Mondrian] Problem Using Dimension Twice

Paul Stoellberger p.stoellberger at gmail.com
Tue May 5 18:36:34 EDT 2015


Yeah, the saiku query model was built with mondrian 3 in mind where hierarchy names worked differently and were always unique.
With mondrian 4 that has changed.

-Paul

On 05 May 2015, at 22:43, Isaias Sanchez <isaias.sanchez.l at gmail.com> wrote:

> Ok
> 
> 
> El mar., 5 de mayo de 2015 20:56, Julian Hyde <julianhyde at gmail.com> escribió:
> And please log that Mondrian bug.
> 
> On May 5, 2015, at 11:08 AM, Isaias Sanchez <isaias.sanchez.l at gmail.com> wrote:
> 
>> Ok, I'll talk to then.
>> 
>> Thanks,
>> 
>> Isaias S.
>> 
>> 
>> El mar., 5 de mayo de 2015 19:54, Julian Hyde <julianhyde at gmail.com> escribió:
>> 
>> On May 5, 2015, at 6:22 AM, Isaias Sanchez <isaias.sanchez.l at gmail.com> wrote:
>> 
>>> WITH
>>> SET [~FILTER] AS
>>>     {[Time].[Year by Weeks].[2015].[2015-05-04].[2015-05-05]}
>>> SET [~ROWS_Destination Info] AS
>>>     {[Destination Info - Client].[Destination Info].[Destination].Members}
>>> SET [~ROWS_Destination Info] AS
>>>     {[Destination Info - Internal].[Destination Info].[ABKHAZIA]}
>>> SELECT
>>> NON EMPTY {[Measures].[Calls]} ON COLUMNS,
>>> NON EMPTY NonEmptyCrossJoin([~ROWS_Destination Info], [~ROWS_Destination 
>>> Info]) ON ROWS
>>> FROM [Traffic Management]
>>> WHERE [~FILTER]
>> 
>> I think Saiku has generated a bad query. It is illegal to have two sets with the same name.
>> 
>> Can you log a bug on Mondrian - it should give an error if set names are not distinct.
>> 
>> Then Mondrian resolves
>> 
>> > NonEmptyCrossJoin([~ROWS_Destination Info], [~ROWS_Destination Info])
>> 
>> and of course it has asking to combine two sets of the same dimensionality.
>> 
>> So the main bug, I think, is in Saiku; it should generate set names based on the use of the dimension (e.g. “~ROWS_Destination Info - Internal”) rather than the shared dimension.
>> 
>> Julian
>> 
>> _______________________________________________
>> 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
> _______________________________________________
> 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/20150506/6c707929/attachment.html 


More information about the Mondrian mailing list