RESOLVED: 10.2.1 Upgrade - Calculation in pass-thru/subquery not functioning

[adam_mc]

Applied Fix Pack 2 - Contains required patch based on calculations from Union Queries.


I have a query (which is the result of a union of two other queries).
Note: I am migrating from 10.1 to 10.2.1 and it is now not working.

I am passing that thru to another query, so as to re-aggregate all the measures to a Chain level as opposed to a Store Detail Level.

So, my driver query has:

Store
Sales
Units

The subquery has:
Sales (aggregate Total)
Units (aggregate Total)

This works without issue.
However, as soon as I add a calculation to the subquery based on those fields in the subquery, it get the following error:

RSV-SRV-0040

      The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.

It does not validate either!
Any thoughts would be appreciated.

Note:
If I select the Items from the driver query instead and base the calculations on these, I have no issues.
However, this does not seem logical to me as I want the calculation to be based on the total values in the subquery.

Thanks in advance,
Adam.