Re: [Olap4j-devel] SF.net SVN: olap4j:[354] trunk/src/org/olap4j

[Paul S. <pau...@as...>]

1)
No the CellSetFormatter shows only 1 member on that axis, olap4j is producing something wrong for that axis, altough the Cell with the actual value (1,187) is correct!

2)
Since I could reproduce the problem in JPivot as well, it must be a mondrian bug. I shall investigate a little bit more and try to come up with a test case for Foodmart

- Paul


On 9 Oct 2010, at 01:41, Julian Hyde wrote:

> Thanks for fixing all that. 
> 
>> 1)
>> the compoundFilter test failing is correct. It works 
>> technically as i expect it, but there seems to be a problem 
>> in the PrintWriter and the Filter Axis
>> When I execute the query in schema workbench (3.1.6) i get 
>> following result:
>> 
>> Axis #0:
>> {[Product].[All Products].[Drink].[Beverages], [Time].[1997].[Q3].[7]}
>> {[Product].[All Products].[Food].[Frozen Foods], 
>> [Time].[1997].[Q3].[7]}
>> Axis #1:
>> {[Measures].[Sales Count]}
>> Axis #2:
>> {[Store].[All Stores].[USA]}
>> Row #0: 1,187
>> 
>> Which is the correct result, two members on the filter axis. 
>> But when I execute that in the Test suite only 1 member shows 
>> up at the Filter axis but the correct amount on the rows.
>> I have noticed that on another occasion already but I can't 
>> tell where the problem really lies for this.
> 
> I think you should get one cell (because one row, one column) and two
> positions on the filter axis, each a tuple 2 members. That's the expected
> result in the test case. I hope that's what olap4j is returning.
> 


>> 2)
>> Secondly I was trying to reproduce my problem with the sort 
>> in a unit test, but this test executes correctly, which 
>> baffles me a bit.
>> I played around with some queries in PAT and olap4j but 
>> couldn't come up with a good test case.
>> But I'm very sure that there is a bug somewhere related to 
>> the NON EMTPY and the sorting.......
>> 
>> Do you have any input on this Julian?
> 
> Sorry I didn't get back to you earlier. I tried to reproduce this issue
> earlier this week. I tried the following query:
> 
> "select NON EMPTY {[Measures].[Unit Sales]} ON COLUMNS,\n"
>             + "  NON EMPTY Crossjoin(\n"
>             + "    {[Product].[All Products]},\n"
>             + "     Order( \n"
>             + "      {[Promotion Media].Children},\n"
>             + "       [Promotion Media].CurrentMember.Name, DESC)) ON
> ROWS\n"
>             + "from [Sales]
> 
> But it gave the correct result, even though it has all of the factors we
> discussed (NON EMPTY, Crossjoin, Order). I can't make progress until I have
> a test case.