| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Beginners OLAP
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an OLAP connection to distribute with an Excel sheet | Excel Discussion (Misc queries) | |||
| What do i enter in the server textbox to access olap? | Excel Discussion (Misc queries) | |||
| OLAP cube and formula | Excel Discussion (Misc queries) | |||
| Creating an offline OLAP cube | Excel Discussion (Misc queries) | |||
| OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
Linear Mode
