Error

[a.giu...@gmail.com]

Hi Xavier,

Another help. Do you have any idea about what it can be?

java.lang.NumberFormatException: For input string: "DGry"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
at java.lang.Double.valueOf(Double.java:475)
at org.olap4j.driver.xmla.XmlaOlap4jCell.getDoubleValue(XmlaOlap4jCell.java:92)
at org.pivot4j.ui.table.TableRenderer.getValue(TableRenderer.java:185)

[a.giu...@gmail.com]

Got another one:

Exception in thread "main" java.lang.NumberFormatException: For input string: "Nike"

at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
at java.lang.Double.valueOf(Double.java:475)
at org.olap4j.driver.xmla.XmlaOlap4jCell.getDoubleValue(XmlaOlap4jCell.java:92)
at org.pivot4j.ui.table.TableRenderer.getValue(TableRenderer.java:185)

at org.pivot4j.ui.table.TableRenderer.renderDataRow(TableRenderer.java:673)
at org.pivot4j.ui.table.TableRenderer$2.handleTreeNode(TableRenderer.java:602)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:852)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableHeaderNode.walkChildrenAtColIndex(TableHeaderNode.java:868)
at org.pivot4j.ui.table.TableRenderer.renderBody(TableRenderer.java:557)
at org.pivot4j.ui.table.TableRenderer.render(TableRenderer.java:421)

[Xavier Cho]

Hi,

Both of them indicates that one of the cells (content area of the grid) contains non-numeric value, like 'DGry', or 'Nike'. I didn't know that the cell can legimately contain non-numeric characters.

Fortunately, it'll be a very easy fix, but I'd like to have a confirmation before I do that. Could you give me a sample MDX that would render such non-numeric values in the content area? Or is there any specification or article I can refer which shows similar usage?

Regards,
Xavier

2014년 4월 1일 화요일 오전 3시 46분 58초 UTC+9, a.giu...@gmail.com 님의 말:

[a.giu...@gmail.com]

Hi Xavier,

First, sorry for using here as a bug tracker. I really forgot that GitHub would be a better place to discuss that.

Well, I don't have too much knowlegde on MDX, and this MDX that I'm facing some problems is used in a legacy system that I want replace with pivot4j implementation.

I don't have an external access to my SSAS, but this is the MDX:

WITH SET [Column_0] AS {[Measures].[Brand],[Measures].[Style],[Measures].[Colour Code],[Measures].[Material],[Measures].[Size],[Measures].[Economic Inventory]}
SET [Row_0] AS {Descendants([Store].[Store].[Total Store],[Store].[Store].[Description])}
SET [Row_1] AS {Descendants([Product Short].[Product].[Total Product],[Product Short].[Product].[Short Description])}

SELECT
NON EMPTY {VisualTotals([Column_0])} On Columns,
NON EMPTY {Filter({CROSSJOIN({VisualTotals([Row_0])},{VisualTotals([Row_1])})},[Measures].[Order Suggestion] > 0)} On Rows
FROM [Retailisation]
WHERE(
[Brand].[Brand].[Description].&[2.6F0]&[1.5484F7],
[Colour].[Colour].[Total Color],
[Gender].[Gender].[Total Gender],
[Order Method].[Order Method].[Order Method].&[Replenish],
[Process Type].[Process Type].[Total Process Type],
[Product Type].[Product Type].[Total Product Type],
)

[Xavier Cho]

Don't worry, just try to use GitHub later in case you find some other issues.

Anyway, could you give me anymore specifics? Full stack trace or at least an error message would help much.

Please give me some details and I'll be looking into the issue immediately.

2014년 4월 1일 화요일 오후 9시 39분 8초 UTC+9, a.giu...@gmail.com 님의 말: