Excel 2003 and 2007 and Select Multiple Items on Pivot AS Cube bug

[Philippe Cand]

Hello,
I have a pivot table connected to a SQL 2005 SP2 Analysis Server.
I set a few limits on the page selectors, 1 region, 1 customer
The pivot works fine, example it returns 100 for this selection.
I add one more limit, I select 1 product
The pivot still works fine. i.e. now it returns 10
I add one or more products by enabling "Select Multiple Items" in the
Product page item.
The pivot will now cease to work.
In Excel 2003, it will return the total of 100 ignoring the multi-select
In Excel 2007, It will return a small value completely false, example 2.5
I reproduce the same query in 3 other places for comparison:
- From the cube browser in VS Studio, result is correct, i.e. 30 for 3
products.
- From ReportingServices using OLAP source, result is correct, 30
- From Query Analyzer against the base tables, result correct, 30
When I look at the queries generated by Excel 2003, 2007 and
ReportingServices I can see that they are all vastly different.

Is Microsoft aware of this issue and if not were can I post a example on how
to reproduce the bug?

Thanks,
Philippe