The Excel 2007 Beta has some bugs/issues preventing many of the BI reports
from working that work today with Excel 2003 and OWC 11 with SSAS 2005.
1. The MDX generated by the Pivot Table uses the MDX Subcube filter rather
than the MDX WHERE clause. This prevents all the time series (e.g.
PrevPeriod) from working. Typical UI tools for SSAS2005 have 2 filter fields
for each type of filter. At least one field needs to use the WHERE clause to
keep normal reports working.
2. The calculated members of a dimension are greyed out in the selection box
and cannot be deselected to format the report. Prevents many formated
reports from being run in Excel 2007
3. The measure format strings are ignored some of the time (they work in the
Browser of the cube)
Very concerning especially with the termination of the one tool that works
today for these reports (OWC) and it is triggering a review of non-Microsoft
presentation tools for BI systems.
Any hope that these issues are recognized and will be corrected by the GFR?

--
Mike L

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc