Thursday, March 22, 2012

Excel 2007 Issue (KB 929766) for Cube Reports; Doesn't Make Any Sense

In short, we have started deploying Office 2007 to our users and Excel is currently the only client we use to interact with our AS2005 cubes.

A few users have reported issues (which I've verified), but the explanation in the KB article doesn't make any sense to me. These reports were originally developed in Excel 2003 and when opening them up in Excel 2007, we'll see a message saying that Excel found unreadable content in the .xls file and after clicking 'Yes' to recover contents of the workbook, we then receive a message that a PivotTable report was discarded due to integrity problems. If I opened up this report in Excel 2003, I don't receive these errors or messages.

Per the KB's explanation (http://support.microsoft.com/default.aspx/kb/929766):

This issue occurs if the following conditions are true:

?The workbook contains a PivotTable that uses key performance indicators (KPIs).?The KPIs are created in the Analysis Services Business Intelligence Development Studio.?One or more of the KPIs have an expression in the Current Time Member property.


Now, we are running 2005 Standard Edition with no SP, but will be deploying SP2 in a few days. Our cubes do not have any KPIs defined. Can I even define KPIs if we are only running Standard Edition?

Any thoughts?
Still stumped here and we're migrating more users to Office 2007.

No comments:

Post a Comment