Nu am putut găsi această intrare. Se afișează rezultate aproximative. Verificați ortografia sau propuneți adăugarea acestui termen în dicționar.
Use the Aggregation tab to define the aggregations that must be performed for each dimension that the cube references. You select the aggregate function that is used to aggregate can also precompute measures along each dimension that the cube references. By default, aggregation is performed for every alternate level starting from the lowest level. The default aggregate function is SUM. For more details on the strategies for summarizing data, see the chapter about summarizing data in the Oracle OLAP User's Guide.
In the example displayed in Figure: Aggregator Operator in a Mapping, you select SUM as the aggregate function.
図: マッピングのアグリゲータ演算子に示す例では、集計関数としてSUMを選択しています。
However, a SELECT statement with aggregate functions in its select list often includes a WHERE clause that restricts the rows to which the aggregate is applied.
しかし、select リストの集合関数による SELECT 文には、多くの場合、その集合関数が適用されるローを制限する WHERE 句があります。
For example, you can use operators, wildcards, as well as sub-selects or aggregate functions.
例えば、演算子、ワイルドカード、サブセレクト 、または 集計関数を使用することもできます。
If desired, select an aggregate function from the Using drop-down list when sorting by values.
値を基準にソートする場合は、使用ドロップダウン・リストから集約関数を選択します。
A totals query is a select query that uses aggregate functions such as Min, Max, Sum, First, and Last to calculate values for a given field.
In the attribute to calculate, use the menu and select an aggregate function such as Count.
計算するアトリビュートで、 メニューを使用し、 Count のような集約関数を選択します。
You use a totals query to find the earliest or latest dates for records that fall into groups or categories. A totals query is a select query that uses aggregate functions such as Min, Max, Sum, First, and Last to calculate values for a given field.
Correlated scalar subqueries are currently supported only if they can be statically determined to return one row (e.g. if the SELECT list contains an aggregate function with no GROUP BY).
現在、相関スカラーサブクエリは、1行を返すように静的に決定できる場合にのみサポートされます(例えば、 SELECT リストに GROUP BY のない集約関数が含まれる場合 ) 。
An aggregate function performs a calculation on a set of values and then returns a single value. For example, Sum, Count, and Avg are three of the aggregate functions that you can use to calculate totals. You can calculate totals for all records or for groups of records. To summarize by group, you must select the field or fields to group by in the query grid.
In the Aggregator operator on the mapping canvas, select the output attribute for which you want to define an aggregate function.
マッピング・キャンバス上のアグリゲータ演算子で、集計関数を定義する出力属性を選択します。
For example, a SELECT statement cannot contain an aggregate function within a predicate in the WHERE clause unless the aggregate function constitutes an outer reference.
たとえば、SELECT 文では、集合関数が外部参照を構成していないかぎり、その集合関数を WHERE 句の述部の中に指定できません。
Conținut posibil inadecvat
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.