OSBI/saiku — Issue #3: Building queries with dimensions with multiple hierarchies
Author: buggtb
Created: 2011-10-11 14:09:24+00:00
State: open

Hello,
I'm having some problems when I select a member in a parent-child hierarchie with some ancestors.
For example:
If I build by my own query: "SELECT
NON EMPTY {Hierarchize({[Dim1].[member1]})} ON COLUMNS,
NON EMPTY {Hierarchize({{[Dim2].[All Dim2]},{[Parent1].[Child1]},{[Parent1].[Child1].[Child2]},{[Parent1].[Child1].[Child2].[Child3]}})} ON ROWS
FROM [Horas]"
this works perfectly and shows all hierarchies with all Totals.

But if I try to do this in a new query in saiku, selecting in columns member1 and in rows Child3 respectively, this throws an exception like this:

"org.olap4j.OlapException: Unable to find a member with name [[Parent1],[Child2],[Child3]]"
As you can see, it try to build a query skipping some members in the hierarchie.

I guess that this is a bug.