[JPivot-devel] JPivot 1.5 - Regression Issue -

[Mustafa A. <ma...@ed...>]

Hi All,

=20

Im noticing a changed behavior in JPivot 1.5 Please let me know if it's
a known issue.

=20

Lets say we have 3 wholesalers (W1, W2, W3) and 3 products (P1, P2, P3)
on rows and time dimension on columns

We have valid data for the following combinations only.

      W1 - P1

      W2 - P1

      W3 - P1

=20

1.	In the OLAP navigatior we have selected All Wholesalers  under
wholesaler and selected individual products (P1,P2,P3) under products.
2.	The initial table view comes with All Wholesalers and Products
P1,P2,P3
3.	Now when you expand All Wholesalers it displays W1,W2,W3 and for
each wholesalers it displays 3 products.
4.	Notice that a combination like W2 - P2 and W2 - P3 is not a
valid one.
5.	Now when you try to expand P2 under W2 then we get Null Pointer
Exception

=20

java.lang.NullPointerException

      at
com.tonbeller.jpivot.mondrian.MondrianQuaxUti.isFunCallTo(MondrianQuaxUt
i.java:615)

      at
com.tonbeller.jpivot.olap.query.ExpGenerator.genExp(ExpGenerator.java:74
)

      at
com.tonbeller.jpivot.olap.query.Quax.genNormalExp(Quax.java:1137)

      at com.tonbeller.jpivot.olap.query.Quax.genExp(Quax.java:1112)

      at
com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQue
ryAdapter.java:136)

      at
com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java
:180)

      at
com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDe
corator.java:54)

      at
com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapMo
del.java:48)

      at
com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent
.java:245)

      at
com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:25
0)

      at
com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234
)

      at
com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)

=20

6.	Alternatively, if you select All Products in the OLAP Navigator
for Products and de-select individual products, then only valid
combinations are displayed in the JPivot. Invalid combinations like W2 -
P2 are automatically suppressed in 1.5

=20

7.	Actually in JPivot 1.3 , all invalid combinations are displayed
and clicking on them just works fine without any exception.

=20

   So it looks to me like when we introduce this auto suppress of
invalid combinations in 1.5, we didn't handle the case that the user
could still bring a invalid combination through his filters and we
should not throw an exception.

=20

    I know it's a complex issue and I tried to explain as much as
possible. If you need any additional information, please let me know. We
are close to release and this issue is a real blocker. I would really
appreciate your timely help in this.

=20

Thanks

Mustafa

=20

This email message is for the sole use of the intended recipient(s) and
may contain confidential information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.

=20