ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object
Cause: A QDR dimension was specified that does not appear in the valueset's dimension list
Action: Specify only dimensions in the valueset's dimension list
https://support.oracle.com/
http://www.oracle.com/
ORA-36270: (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values
Cause: One or more duplicate values appeared in the AGGREGATION parameter list
Action: Remove the duplication
ORA-36269: (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension
Cause: A nonexistent or invalid object was specified as a QDR dimension
Action: Specify existing dimensions only
ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value
Cause: The AGGREGATION parameter list included a value that does not exist in the MODEL dimension that contains the target of the AGGREGATION
Action: Specify only values from the appropriate MODEL dimension
ORA-36267: (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference
Cause: A dimension qualification was specified for a valueset with no dimensions
Action: Remove the qualification
ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function
Cause: The AGGREGATION function was used outside of the MODEL context
Action: Use AGGREGATION only in a model
ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J
Cause: The partitioning scheme was such that while aggregating there exists a cell (m) such that both one of its descendants and one of its ancestors are both in the referenced partition, while (m) is in a different partition
Action: Change the partitioning scheme
ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity
Cause: In the partition creation / aggmap creation a situation developed such that when aggregating over a particular dimension of the aggmap a partition boundary was crossed such that the sparsity of the target partition included dimensions that were not in the sparsity of the source partition. Since the process of aggregation always densifies rather than sparsifying this is an extremely suboptimal design and it is not supported by the aggregate system
Action: Set up your partitioning such that for any partition boundary the source and target partitions of the aggregation will always move towards denser partitions. For any child (c) and any parent (p) where (c) and (p) are in different partitions it must be the case that the parent partition contains no dimension in the composite that the child partition does not contain in its composite
ORA-36258: (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP
Cause: The AGGMAPINFO function was called with an object that is not an AGGMAP
Action: Modify the call to AGGMAPINFO to specify an AGGMAP object
ORA-36224: (XSLPDSC05) workspace object is not a loop dimension
Cause: An IGNORE or DENSE list in a dimension loop descriptor referenced a dimension (or a valueset of a dimension) that was not a base dimension of the loop dimension list
Action: Remove the dimension or valueset from the IGNORE or DENSE list