ExcelBanter - Beginners OLAP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Beginners OLAP (https://www.excelbanter.com/excel-discussion-misc-queries/27226-beginners-olap.html)

What are the differences between OLAP & Pivot tables?

We use pivot tables extensivley, and recenlty upgraded our db's to SQL and
wondered if OLAP was more powerful that using Pivot Tables.

How do I start OLAP reports using Excel & SQL?

Tia

Jonathan

There's information on the Microsoft site. For example:

How to Build Business Solutions with Microsoft SQL Server OLAP Services
and Excel 2000
http://www.microsoft.com/technet/com.../tnq10007.mspx

OLAP Related Features in Microsoft Excel 2002 and the Microsoft Office
XP Web Components

http://msdn.microsoft.com/library/de..._XLOWCOlap.asp

Jonathan wrote:
What are the differences between OLAP & Pivot tables?

We use pivot tables extensivley, and recenlty upgraded our db's to SQL and
wondered if OLAP was more powerful that using Pivot Tables.

How do I start OLAP reports using Excel & SQL?

Tia

Jonathan

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html