Oracle Error ORA-36621: (XSAGMODDIM02) You cannot AGGREGATE the individual partition using static model workspace object because a partition dimension or its deriver workspace object appears in the equation of the step or simultaneous block.

Oracle Error Message

ORA-36621: (XSAGMODDIM02) You cannot AGGREGATE the individual partition using static model workspace object because a partition dimension or its deriver workspace object appears in the equation of the step or simultaneous block.

Reason for the Error

An attempt was made to AGGREGATE the individual partition using the static model with the partition dimension in the equation of the step or simultaneous block.

Solution

AGGREGATE the variable instead of the individual partition.