Parent-child hierarchies do not render correctly with showParentMembers = true

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 99 forks source link

Parent-child hierarchies do not render correctly with showParentMembers = true #77

Closed mysticfall closed 11 years ago

mysticfall commented 11 years ago

Parent-child hierarchies do not render correctly when the 'showParentMembers' property is set to 'true'.

SELECT {[Measures].[Number of Employees]} ON COLUMNS, Hierarchize(Union(Union(Union({[Employees].[All Employees]}, [Employees].[All Employees].Children), [Employees].[Sheri Nowmer].Children), [Employees].[Sheri Nowmer].[Derrick Whelply].Children)) ON ROWS FROM [HR]