The SQL generated by the previous instructions has only a single grouping set in the GROUP-BY clause.
前面步骤产生的SQL在GROUP BY子句中只有一个分组集。
While the ordering of the grouping columns does not matter for a single grouping set or multiple grouping sets, the order of the columns does matter for ROLLUP.
对于单一分组集或多个分组集,分组列的次序是无所谓的;但是对于ROLLUP,列的次序不能随意安排。
To create a grouping set at another slice of the cube model, create a new grouping set that includes, at a minimum, the level key attributes of each level in the new slice.
要在多维数据集模型的另一个切片上创建分组集,应该创建一个新的分组集,其中至少要包含新切片中每一级的级键属性。
应用推荐