其他汇总的实现

原创于 2014-05-26 23:01:00 发布 · 626 阅读

0 ·

CC 4.0 BY-SA版权

OLAP 专栏收录该内容

10 篇文章

订阅专栏

SUM			
COUNT			
AVG			
DISTINCTCOUNT		
MAX			
MIN			


扩展[Measures].currentMember.aggType的属性

with member [DIM].[MEM] as
case 
  when [Measures].currentMember.AggType = 'sum'
    then Aggregate([ALL]) - Aggregate([SET])
  when [Measures].currentMember.AggType = 'count' || [Measures].currentMember.AggType = 'distinct-count'
    then Aggregate(Except([ALLs], [ALL])) - Aggregate([SET])
  when [Measures].currentMember.AggType = 'avg'
    then (Aggregate([ALL]) - Aggregate([SET]))/(Aggregate(Except([ALLs], [ALL])) - Aggregate([SET]))
  when [Measures].currentMember.AggType = 'max'
    then Aggregate([ALL])
  when [Measures].currentMember.AggType = 'min'
    then Aggregate(Except([ALLs], [SET]))
else null end

select [Measures]... on COLUMNS/ROWS,
[DIM].[MEM] on ROWS/COLUMNS
from [Cube]
where ...

RolapBaseCubeMeasure
getPropertyValue(Property.AGGREGATION_TYPE.name) == RolapAggregator.COUNT