Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1 Query on ragged hierarchy gives only empty cells

closed
Julian Hyde
None
5
2012-10-08
2008-01-10
Will Gorman
No

When executing the below query, olap4j returns all empty cells. When running the same query in mondrian, 18 of the 24 cells have data.

SELECT
{[Product].[All Products].[Drink].[Alcoholic Beverages].Children,
[Product].[All Products].[Food].[Baked Goods].Children} ON COLUMNS,
CrossJoin([Store].[All Stores].[USA].[CA].Children,
[Time].[1997].[Q1].Children) ON ROWS
FROM [Sales Ragged]

olap4j code:

CellSet cellSet =
olapStatement.executeOlapQuery(
"SELECT " +
"{[Product].[All Products].[Drink].[Alcoholic Beverages].Children, [Product].[All Products].[Food].[Baked Goods].Children} ON COLUMNS, " +
"CrossJoin([Store].[All Stores].[USA].[CA].Children, [Time].[1997].[Q1].Children) ON ROWS " +
"FROM [Sales Ragged]");

Discussion

  • Julian Hyde
    Julian Hyde
    2008-11-04

    Works for me as of revision 133, on mondrian driver. Added testcase ConnectionTest.testRagged.