However, aggregation functions, such as avg, do not work with the timestamp duration because the duration is computed based on the numerical value 但是,聚合函數(shù),如avg等,并沒有在時(shí)間戳的持續(xù)時(shí)間內(nèi)工作,這是因?yàn)樵摮掷m(xù)時(shí)間是以數(shù)值為基礎(chǔ)進(jìn)行計(jì)算。
If the measure had a third aggregation, then the select statement generated here would itself be used as a subselect on which the third aggregation function would be applied )如果這個(gè)度量還有第三個(gè)聚合,那么這個(gè)選擇語(yǔ)句本身作為子查詢,第三個(gè)聚合函數(shù)應(yīng)用于它。
When generating sql expressions for measures that reference other measures, the aggregation function might not be used to form the sql expression for the nested measures 如果一個(gè)度量引用其他度量,那么在為它產(chǎn)生sql表達(dá)式時(shí),不能使用聚合函數(shù)來(lái)為嵌套的度量產(chǎn)生sql表達(dá)式。
If the multiple measures apply their aggregation functions on the same dimensions and in the same order as each other, the measures can all be calculated in the same statement 如果多個(gè)度量將它們的聚合函數(shù)應(yīng)用于同樣的維,而且次序相同,那么可以在同一個(gè)語(yǔ)句中計(jì)算這些度量。
The model described a multi-dimension fact relation map based on relationship between dimension and fact and defined the multi-dimension hierarchy through using aggregation function 在該模型中,基于維與事件的關(guān)系,描繪了多維事件關(guān)系圖,并利用非奇異聚集偏序集簇定義了維的結(jié)構(gòu)。
If the current measure has an aggregation function, then when forming the sql expressions for any referenced measures, the aggregation function of these measures should not be applied to the sql expression template 如果當(dāng)前度量有聚合函數(shù),那么在為引用的任何度量產(chǎn)生sql表達(dá)式時(shí),這些度量的聚合函數(shù)不應(yīng)該應(yīng)用于sql表達(dá)式模板。
If the current measure has an aggregation function, then when forming the sql expressions for any referenced measures, the aggregation function of these measures should not be applied to the sql expression template 如果當(dāng)前度量有聚合函數(shù),那么在為引用的任何度量產(chǎn)生sql表達(dá)式時(shí),這些度量的聚合函數(shù)不應(yīng)該應(yīng)用于sql表達(dá)式模板。
If there are any dimensions that need to be aggregated using a different aggregation function, then the query must also select and group the attributes in the facts object, which are used to join to those dimensions 如果有任何維需要使用不同的聚合函數(shù)進(jìn)行聚合,那么查詢還必須采用事實(shí)對(duì)象中用來(lái)聯(lián)結(jié)這些維的屬性進(jìn)行選擇和分組。
Unlike symmetric measures, which have one aggregation function applied to the sql expression template for all of the dimensions, asymmetric measures will have multiple aggregation functions applied to the sql template 對(duì)于對(duì)稱的度量,要將一個(gè)聚合函數(shù)應(yīng)用于所有維的sql表達(dá)式模板;但是非對(duì)稱度量有多個(gè)聚合函數(shù)要應(yīng)用于sql模板。
Unlike symmetric measures, which have one aggregation function applied to the sql expression template for all of the dimensions, asymmetric measures will have multiple aggregation functions applied to the sql template 對(duì)于對(duì)稱的度量,要將一個(gè)聚合函數(shù)應(yīng)用于所有維的sql表達(dá)式模板;但是非對(duì)稱度量有多個(gè)聚合函數(shù)要應(yīng)用于sql模板。