| Easy Heading Macro | ||||||
|---|---|---|---|---|---|---|
|
2차 계산 함수는 SQL로 계산된 1차 집계 데이터에 대해, Olap 서버 상에서 퍼센트/비율/누계/기초/기말 등의 재계산이 필요한 경우 적용합니다.
2차 계산 함수
[ 2차 계산 함수 리스트 ]
...
None
...
Secondary calculation functions are applied on the OLAP server when recalculations such as
percentage, ratio, cumulative total, opening, or closing values are needed based on the primary aggregated data calculated via SQL..
[ Secondary Calculation Function ]
| Secondary Calculation Function | Description | Base Field Needed |
|---|---|---|
None | No calculation based on aggregation | N/A |
Absolute |
Returns the absolute value | N/A |
Percent |
Returns the percentage of the Grand Total value | N/A |
PercentOfColum | Returns the percentage of the Colum Total |
value | N/A |
PercentOfRow | Returns the percentage of the Row Total |
value | N/A |
SubTotalPercentOfColumn |
Returns the percentage of the Group Column Total |
value | N/A |
SubTotalPercentOfRow |
Returns the percentage of the Group Row Total |
value | N/A |
RunningAverage |
그룹 내 누적기준으로 이동평균값 반환
필요
RunningCount
그룹 내 누적기준으로 데이터 건수 반환
필요
RunningMax
그룹 내 누적기준으로 최대값 반환
필요
RunningMin
그룹 내 누적기준으로 최소값 반환
필요
RunningProduct
그룹 내 누적기준으로 값에 대한 곱하기 결과 반환
필요
RunningSum
그룹 내 누적기준으로 합계값 반환
필요
FirstPeriod
그룹(기간 디멘젼)내 첫 번째 멤버의 메져값 반환
필요
LastPeriod
그룹(기간 디멘젼)내 마지막 멤버의 메져값 반환
필요
PeriodIncrease
그룹(기간 디멘젼)내 이전 멤버의 메저값 대비 증감값 반환
필요
PeriodIncreaseRate
그룹(기간 디멘젼)내 이전 멤버의 메저값 대비 증감율 반환
필요
...
Returns the moving average based on cumulative values within the group | Needed | |
RunningCount | Returns the number of data records based on cumulative values within the group | Needed |
RunningMax | Returns the maximum value based on cumulative values within the group | Needed |
RunningMin | Returns the minimum value based on cumulative value within the group | Needed |
RunningProduct | Returns the product of values based on cumulative values within the group | Needed |
RunningSum | Returns the sum values based on cumulative values within the group | Needed |
FirstPeriod | Returns the measure value of the first member within the group (period dimension) | Needed |
LastPeriod | Returns the measure value of the last member within the group (period dimension) | Needed |
PeriodIncrease | Returns the increase/decrease value compared to the previous member's measure value within the group (period dimension) | Needed |
PeriodIncreaseRate | Returns the increase/decrease rate compared to the previous member's measure value within the group (period dimension) | Needed |
Example of Secondary Calculation
[ PercentOfRow ]
[ PercentOfColumn ]
...