CCC pieChart visualization

165 Views Asked by At

I'm moving from JfreeChart to CCC. I'm able to show a CCC chart using a MDX query. I have a problem: what I have to change in my MDX query which allowed to show a pie chart in JfreeChart component, but not in CCC one? The query is the following:

with member [Measures].[Total] as '([DIM_X].[A], [Measures].[COUNT])' 
     member [Measures].[Perc] as '([Measures].[COUNT] * 100) / [Measures].[Total]' 
     set [Percent over threshold] as 'Filter([DIM_X].[A].Children, [Measures].[Perc] >= 4)' 
     member [DIM_X].[Others] as 'Aggregate({Filter([DIM_X].[A].Children, [Measures].[Perc] < 4)})' 
select NON EMPTY {[Measures].[COUNT]} ON COLUMNS, 
NON EMPTY {[Percent over threshold],[DIM_X].[Others]} ON ROWS 
from [CUBE]

Why the result set of this query is shown in a pie chart in the JFreeChart component and not in CCC one? Another detail: in the CCC component I'm able to show the result set of the posted query Line or Bar chart.

0

There are 0 best solutions below