Summary: | Cross tab - Function list for measures and totals | ||
---|---|---|---|
Product: | z_Archived | Reporter: | Rima Kanguri <rkanguri> |
Component: | BIRT | Assignee: | Birt-Report-inbox <Birt-Report-inbox> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | normal | ||
Priority: | P1 | CC: | lzhu, whe, xxue |
Version: | 2.2.0 | ||
Target Milestone: | 2.2.0 RC3 | ||
Hardware: | PC | ||
OS: | All | ||
Whiteboard: |
Description
Rima Kanguri
2007-05-16 15:09:07 EDT
-Please assign to UI team after hte model changes are done. - We dont want to expose the functions that we dont plan to support, hence i have marked this bug for RC0 Model part is fixed. GUI will call IMetaDataDictiony.getElement().getProperty().getAllowedChoices to get the list of the functions defined in cube measure. And in the similar way get the allowed function list in aggregation. Model changes are done. UI Changes ----------- 1) UI should show the "cube measure" list in the cube builder 2) UI should show the cross tab subtotal/grand total function list in the cross tab UI GUI has fixed against 187499. I just noticed that the list shown by GUI for the cross tab aggregation builder is not correct. It should be the list described in list (2) of the bug description. For cube measure, we should display: SUM AVERAGE MAX MIN FIRST LAST COUNT COUNTDISTINCT For cube grand total, sub total, we should display: SUM COUNT AVERAGE WEIGHTEDAVG MAX MIN STDDEV FIRST LAST MODE MEDIAN VARIANCE COUNTDISTINCT For normal computed columns, we should all available Total.* functions. So for cross tab total and sub total, we should only support a subset of currently supported BIRT Total function, rather than a full set. Meanwhile in the aggregation builder of all a table we should support full set of Total functions. For BIRT 2.2 we will support the following 1)Cube Measure – We will only support subset of functions, following is the list SUM AVERAGE MAX MIN FIRST LAST COUNT COUNTDISTINCT 2)Cross tab subtotal and grand total function SUM COUNT AVERAGE WEIGHTEDAVG MAX MIN STDDEV FIRST LAST MODE MEDIAN VARIANCE COUNTDISTINCT 3) Table function list SUM COUNT AVERAGE WEIGHTEDAVG MAX MIN STDDEV FIRST LAST MODE MEDIAN VARIANCE COUNTDISTINCT isTopN isTopNPercent isBottomN isBottonNPercent movingAve, percentile, percentSum, percentileRank, quartile, rank, runningcount, runningSum, After cross-team discussion, got following agreements: ComputedColumn supports all aggregation functions. Crosstab sub and grand total should only support a subset of functions as comments#8 illustrated. To constrain the list for crosstab subtotal and grand total, UI need to hardcode since in the ROM schema level, we have no easy way to distinguish two scenarios. Fixed. |