Each dimension must be aggregated using one aggregation function from the measure object 每個維必須使用來自度量對象的一個聚合函數(shù)進行聚合。
If total expense does not have an aggregation function, in this case, the aggregation functions for 如果totalexpense沒有聚合函數(shù),在這種情況下,就要使用
If total expense does not have an aggregation function, in this case, the aggregation functions for 如果totalexpense沒有聚合函數(shù),在這種情況下,就要使用
Section to modify the default aggregation function associated with each account type in the selected database 部分可以修改與所選數(shù)據(jù)庫中每個帳戶類型相關(guān)聯(lián)的默認聚合函數(shù)。
Each of the aggregation functions used to aggregate the measure value along with the dimensions specified for the aggregation 用來對度量值進行聚合的每個聚合函數(shù)都指定了對應(yīng)的維。
If a measure has more than one aggregation function in its list of aggregations, then the measure is an asymmetric measure 如果一個度量在它的聚合列表中有多個聚合函數(shù),那么這個度量就是非對稱的度量。
Will not be used when generating the sql expression for total expense since aggregation functions cannot be nested within other aggregation functions )的聚合函數(shù),因為聚合函數(shù)不能嵌套在其他聚合函數(shù)中。
Will not be used when generating the sql expression for total expense since aggregation functions cannot be nested within other aggregation functions )的聚合函數(shù),因為聚合函數(shù)不能嵌套在其他聚合函數(shù)中。
Then apply the aggregation function to the sql expression resulting from the sql expression template to form the sql expression for the measure 然后,對從sql表達式模板產(chǎn)生的sql表達式應(yīng)用聚合,形成度量的sql表達式:
The order of when each aggregation function is applied is also important and needs to be done according to the order of the aggregations listed in the measure 應(yīng)用每個聚合函數(shù)的次序也很重要,需要根據(jù)度量中列出聚合的次序來安排。