ORA-36176: (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE
Cause: The user specified an illegal relation as a weight. The relation might have been multidimensional, not a self-relation, or not a relation over one of the bases of the aggregation variable
Action: Specify a valid self relation over one of the bases of the aggregation variable
https://support.oracle.com/
http://www.oracle.com/
ORA-36174: (XSMXAGGR23) workspace object must be either a VARIABLE, a RELATION or a FORMULA
Cause: The user specified something that was not a variable, a relation or a formula as a weight for AGGREGATE
Action: Specify a valid variable, relation or formula instead
ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string
Cause: The user specified a WEIGHT variable or formula which wasn't numeric or boolean
Action: Specify a numerical or boolean weight instead
ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
Cause: The user specified a COUNTVAR variable which is missing at least one dimension of the aggregation variable
Action: Specify a COUNTVAR variable which has at least as many base dimensions as the aggregation variable
ORA-36167: (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA
Cause: The user attempted to aggregate a FORMULA using an AGGMAP that is not valid for aggregating FORMULAs. The AGGMAP must specify PRECOMPUTE(NA) for all relation lines and must not specify any caching
Action: Correct the AGGMAP so it is legal for aggregating a FORMULA
ORA-36166: (XSMXAGGR08) workspace object is not a VARIABLE
Cause: An attempt was made to perform an AGGREGATE or other action on an object which is not a variable
Action: Specify a variable instead
ORA-36165: (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property
Cause: An attempt was made to add the $COUNTVAR property to a variable which already had an AGGCOUNT, or vice versa
Action: Delete the already existing $COUNTVAR property or AGGCOUNT first
ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number)
Cause: The user specified a COUNTVAR clause to the AGGREGATE command, but the number of COUNTVAR variables specified did not match the number of variables to be aggregated
Action: Specify a separate COUNTVAR for each variable
ORA-36163: (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time
Cause: The user named several variables to be AGGREGATED within a call to the AGGREGATE function
Action: The AGGREGATE function should be used to produce a single numeric value from aggregating a single variable. The AGGREGATE command can be used to precompute aggregations of several different variables
ORA-36162: (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string
Cause: The user specified a non-INTEGER variable as a COUNTVAR for aggregation
Action: Redefine the COUNTVAR to be an INTEGER