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

Support nested MDX #151

Open mysticfall opened 10 years ago

mysticfall commented 10 years ago

We need to support using a nested MDX query like this : 

SELECT
{[Measures].[Transaction_Count],[Measures].[Transaction_Amount]} ON columns,

[DIM_DEFINITE_DATE].[DAY_OF_MONTH].[DAY_OF_MONTH].MEMBERS
ON rows
FROM
(SELECT [DIM_TERMINAL_UNIVERSAL].[TERMINAL_ID].[@TERMINAL_ID] ON 0 FROM
(SELECT [DIM_CUSTOMER_UNIVERSAL].[CUSTOMER_BRANCH_ID].[@CUSTOMER_BRANCH_ID] ON 0 FROM
(SELECT [DIM_CUSTOMER_UNIVERSAL].[CUSTOMER_ID].[@CUSTOMER_ID] ON 0 FROM  
[ACQCUBE]
)))