Pivot tables connected to SSAS issues

With the latest Office 2007 beta, I have found a couple of features that work
in Excel 2003 and OWC 11 but not in Excel 2007.
1. The formating of fields "#%" and "Currency" is ignored (works on some
FORMATS and works in the Cube Browse of BI Studio.
2. The calculated Measures on a non measure dimension do not display in the
field list.
3. Sadly, the generation of a web page with OWC 11 Pivot Table control is no
linger supported.
It is hard to demo and recommend 2007 until it works as well as Excel 2003.
Thoughts?
--
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

I have refined my calculated measures on a separate attribute of the Date
dimension and sitill find that they work well with Excel 2003 but do not show
up in Excel 2007. There is an MDX function .Members that excludes Calculated
Measures from display and another function .AllMembers that includes
Calculated measures. I am guessing that this is a bug with Excel 2007 Beta 2
using the incorrect MDX call.
A bit disappointing because I find many other aspects of Excel 2007 great in
this area but my reports depend heavily on Calculated members on Date
attributes (such as created by the All Business Intelligence (Time
Inteligence) wizard of SSAS).

Anyone else confirm this issue with Excel 2007?

--
Mike L


"Mike L" wrote:

> With the latest Office 2007 beta, I have found a couple of features that work
> in Excel 2003 and OWC 11 but not in Excel 2007.
> 1. The formating of fields "#%" and "Currency" is ignored (works on some
> FORMATS and works in the Cube Browse of BI Studio.
> 2. The calculated Measures on a non measure dimension do not display in the
> field list.
> 3. Sadly, the generation of a web page with OWC 11 Pivot Table control is no
> linger supported.
> It is hard to demo and recommend 2007 until it works as well as Excel 2003.
> Thoughts?
> --
> 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