Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In?

A

Alan Whitehouse

Hi,

I am accessing some cubes created with Analysis Services on SQL 2005.

Wondering if anyone has a link to a website or document that can detail the advantages (if any) of using the Cube Analysis add-in to Excel 2003 to access these cubes versus creating an external data connection to the OLAP cubes through the standard Pivot Tables functionality.

So far I am not seeing the value of this Cube Analysis add-in and was trying to find something to either back-up or change my opinion.

Thanks.

Alan
 
J

Jim Thomlinson

Careful with that cube analysis addin. One side effect that it has is that it
turns events off and then neglects to reset them when it is done. This means
that any macros you have that use event handlers such as on open or on change
will no longer work properly. It is a royal pain.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[PS 2007] cube building problem 1
Excel 2007 pivot table using analysis services cube as data source 0
Failed to build the OLAP cubes 2
Data in Data Analysis Cube 0
Alternatives to MS Query for Pivot Tables & Cubes 0
Cube buiding error - Analysis Services permissions 3
OLAP Cube build error 6
Cube building in MPP Server 2007 Standalone 4

Top