—增加汇总函数。
如果它必须出现在模型中,但又被抑制了,那么要考虑在该级别上使用汇总函数。
If it has to be in the model and it is suppressed consider using the summarizing function on the level above.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
例如,如果使用了IQD,那么您必须编辑这个 IQD,加入正确的分组和汇总函数。
For example if an IQD is used you may have to edit the IQD to introduce appropriate Grouping and Summary functions.
平均值、合计和其他类型的汇总数据无法通过仅仅使用一个映射函数来实现。
Averages, summations, and other summary types of data are not possible with just a map function.
清单2中提供的示例说明用于将列表缩减为标量的其他SCSH函数 —在这种情况下,用 (1 + (2 + (3 + (4 + (5))))) 的格式汇总值的列表。
The example provided in Listing 2 illustrates another SCSH function for reducing a list to a scalar—in this case, summing the list of values in the form (1 + (2 + (3 + (4 + (5))))).
像SQL一样,XQuery包含从多个数据集中提取数据、汇总数据、聚合数据和连接数据的函数。
Like SQL, XQuery contains functions for extracting, summarizing, aggregating, and joining data from multiple datasets.
作为一个额外的奖励,请注意reduce函数可以是相同的,因为它只汇总已分组的键!
As an added bonus, note that the reduce function can be the same because it just sums up grouped keys!
下一步,我不得不定义reduce函数(如清单15所示),其采用了所有相应分组文档并汇总这些值。
Next, I have to define a reduce function (shown in Listing 15), which takes all the correspondingly grouped documents and sums up the values.
count函数非常有用,可以在任何级别显示汇总表中的每个汇总行由多少条记录组成。
The COUNT function is very useful to show at any level how many records make up each aggregated row in the summary table.
第三个参数是rereduce,这个参数必须处理这个reduce函数是在汇总信息上操作还是在来自映射的原始结果(来自map 函数的结果)上操作。
The third argument, rereduce, has to do with whether or not this reduce function is operating on aggregate information or the raw results from the map (the ones from the map function).
在使用函数框里,选择要计算分类汇总的函数。
In the use function box, select the function that you want to use to calculate the subtotals.
当使用聚合函数时,默认情况下,汇总信息包含所有指定的行。
When you use an aggregate function, by default the summary information includes all specified rows.
可将聚合函数同其他表达式组合使用,以计算其他汇总值。
You can combine aggregate functions with other expressions to calculate other summary values.
可将聚合函数同其他表达式组合使用,以计算其他汇总值。
You can combine aggregate functions with other expressions to calculate other summary values.
应用推荐