Advantages of OLAP Cube vs. Pivot Table? 1

[DeLaMartre]

Just a general question which I haven't been able to resolve: Are there any computational advantages of using an OLAP cube, as compared with using a pivot table.

I can't seem to find any real benefits, and I am wondering if it is worth my while to become more informed about cubes.

Any advice would be very much appreciated.

Thanks,

-Bob in California

 

[SkipVought]

Bob,

In general, an OLAP pre-queries data at various levels to improve performance. You would only notice a difference when querying a very large database.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[DeLaMartre]

Thanks very much for the insight, Skip! Your sage advice is always appreciated.

-Bob in California