search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 101 forks source link

Ragged hierarchy with 'show parent' option fails to render correctly #150

Closed mysticfall closed 10 years ago

mysticfall commented 10 years ago

Running the following MDX with 'Show Parent' button pressed results in broken table layout : 

SELECT NON EMPTY {[Measures].[Store Sales], [Measures].[Store Cost], 
[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY Hierarchize(Union(Union({
[Store].[Israel], [Store].[USA], [Store].[Vatican]}, [Store].[Israel].Children), 
[Store].[Israel].[Haifa].Children)) ON ROWS FROM [Sales Ragged]

We should update HtmlRenderIT.testRaggedHierarchy() test case to cover this issue.

mysticfall commented 10 years ago

Managed to fix this one, but issues related to ragged members (like #76) cannot be fixed completely on Pivot4J's side alone, as it involves an issue of another project(i.e. Mondrian).

Along with member cache stuffs, the whole thing is a hackish workaround which unfortunately affects the codebase very pervasively, making it hard to maintain.

So, I'll deal with any future issues with ragged members as 'fix it if reported' basis, and wait till the upstream issue to be fixed.