•   Reporting off of cubes is different from reporting off of transactional data.

    Yes, we have found that to be the case.  The solution provided seems to use transactional data.  SSAS is obviously aggregating the data correctly, because it displays correctly in Excel.  And if we remove the parent-child dimension from the report and only use a regular dimension, the totals perform as expected.  We have found using an SSAS parent-child in SSRS to be a "challenge."  This is the latest one.