I have isolated the problem as much as I can, and have attached (zipped) a QV file reproducing the problem.
Here is what I've done and where I'm at:
1. I discovered that I could eliminated the "exceeded allocated memory" error but removing any ORG units that are not referenced by any of my fact records. However, this has effectively shifted the problem to incorrect values calculated in my chart expressions. These problems go away on a smaller selection, so I have reason to believe that the memory issue and incorrect calculations are related.
2. I have reduced the data set to as small as possible (any smaller and the problem goes away).
3. The problem is that the Chart expression is not calculating the number of aggregations correctly. Based on the logic of the chart expression, and how I am aggregating, the total value cannot exceed the number of distinct values for "ORG1_MemberName7". In the 32 bit version of QV, this always holds true, in the 64 bit version this number goes much higher, unless I reduced the number of underlying fact records that are selected.
Here are the dimensions:
Here is the expression:
count($(NationalOrgSet) total <SG1_QShortDesc2, SG1_QShortDesc3>
ORG1_MemberName7, SG1_QShortDesc2, SG1_QShortDesc3
So, I believe the bug is related to: 64-bit with aggregation functions contained within an aggregate function using the "total" keyword with the pivot dimensions.
Any help is much appreciated.