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

Incorrect table layout when member levels are not contiguous #23

Closed mysticfall closed 11 years ago

mysticfall commented 11 years ago

Incorrect table layout is generated when member levels are not contiguous.

Test MDX :

SELECT {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS, CrossJoin({[Promotion Media].[All Media]}, {[Product].[All Products], [Product].[Drink], [Product].[Drink].[Beverages].[Carbonated Beverages], [Product].[Drink].[Beverages].[Drinks], [Product].[Drink].[Beverages].[Hot Beverages], [Product].[Drink].[Beverages].[Pure Juice Beverages], [Product].[Food], [Product].[Non-Consumable]}) ON ROWS FROM [Sales] WHERE [Time].[1997]