PivotTable Compatibility

re: PivotTable Compatibility

A User — Wed, 30 Aug 2006 20:23:41 GMT

Regarding Key Performance Indicators (KPI) and other Analysis Services (AS) functionality:

Firstly, the choice to provide an affordance narrowly tailored to KPI is distinctly odd. Sure, KPI is a useful framework, but if you are going to implement this general kind facility to hook into external systems, why not a general purpose facility that could readily afford the whole spectrum of BI frameworks.

Secondly, I guess I understand why this functionality is bundled in Excel rather than being an add-in bundled with AS. But it seems as crazy as, hypothetically, web authoring in MS products generating pages that can only be read with your own internet browser product. Crazy like a fox. I am a heavy user of another provider's OLAP product, which is bundled with an Excel add-in. The only use I have for AS is to make idle threats when negotiating prices with my OLAP provider. I actually would not touch it with a ten foot pole. I am not pleased to see AS glop embedded in Excel.

re: PivotTable Compatibility

JP3 — Sat, 09 Sep 2006 08:44:58 GMT

This is perhaps not the best place to post, but I have a question about the MSFT "Excel Addin for SSAS" and its future in relation to Office 2007.

I can see that the new Pivot Table functionality makes the addin largely redundant...but what about the ability to construct "free form" reports? Is there going to an equivalent for Excel 2007 or is the intention to rely on SSRS to provide this type of complex report construction?

Pivot Tables/Excel 2007/.xls format - Save before you start

Nate Oliver's blog — Mon, 25 May 2009 20:18:19 GMT

Happy Memorial Day! Right - Excel. I'm a fly by the seat of my pants kind of guy, crunch data now