Group aggregation functions based on dimension items (such as sum, max, min, count, calculation, distinct count, and text) are defined.
Primary calculations are executed on the OLAP server, not through queries.
[ Primary Calculation Function ]
Aggregation | Description |
|---|---|
None | No calculation based on aggregation |
Sum | Total value |
Min | The minimum value |
Max | The maximum value |
| Average | The average value |
| Count | Number of data records |
| Calculate | Automatically changes to Calculate when a formula is written for the property Do not arbitrarily set this value |
| DistinctCount | Number of data records after removing duplicate values |
| Text | Returns the field value of the first record in text |
Example of Primary Calculation
- Total value for Target Amount, Revenue Amount, Sales Cost, and Discount Amount.
[ Primary Calculation Function Application ]
[ Primary Calculation Query on i-CHECK ]
Query is written using the calculation functions defined in the analysis item settings,
and the primary calculation is performed separately on the OLAP server
