I do have a
strange issue with Excel 2007 pivot table report; the data source is
SSAS 2008 cube. When refresh the excel 2007 report data using the
'Refresh All' or 'Refresh' button available under the Data menu, the below error is thrown.
"The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples."
After some analysis, the report works well on the below workaround,
1. Remove all the calculated measures from report (3 measures in this scenario)
2. Remove one row label (dimension attribute) from report
But the measures, attributes are valid one from cube and it is required fields in the report. So, understand that removing few items is not at all a solution.
The below workaround also works.
Check the 'Defer Layout Update' option from the Pivot Table Field List window.
2. Click on the
After that Unchecked the 'Defer Layout Update' option and apply the filter, etc in the report. The report works very well. But every time, we need to use the above work around
after open the excel report.
I have NO clue on this issue. Please help to resolve this issue.
View Complete Post