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

Widening show parent #91

Closed klaudiusz223 closed 11 years ago

klaudiusz223 commented 11 years ago

I wonder whether show parent feature should be wider. Now it shows only levels which were involved in the query. I think it should always show all ancestors. For example in query SELECT {[Time].[1997].[Q1].[1]} ON ROWS, {[Measures].[Store Invoice]} ON COLUMNS FROM [Warehouse] With "show parent" there is only Month (| 1 |). Should it be Year, Quarter, Month (| 1997 | Q1 | 1 |)?

mysticfall commented 11 years ago

It's fairly easy to do.

However, I found a critical issue by running your MDX of [Time].[1997].[Q1].[1] member shown as a measure.

It's a bug introduced by #79 again. I guess the workaround did break too many premises the existing codebase relies upon.

I think it's a rather critical problem, so I filed it as #94, and will fix it immediately.