What are the requirements to run OLAP cubes? Can I run OLAP with Office 97 Suite?
OLAP typically requires a database to store the detailed information that gets aggregated in a multidimensional analysis. This database can be either a standard relational database with a special query engine or a standalone multidimensional database. The former is called ROLAP (Relational OLAP) while the latter is usually referred to as MOLAP (Multidimensional OLAP).
As I understand it, Microsoft Office does not come with any built-in OLAP capabilities. The closest that you can get to OLAP is the pivot table capabilities built into Microsoft Excel. Pivot tables give you some basic multidimensional aggregations but for any significant analysis you will need something more sophisticated. Microsoft's SQL Server database does provide integrated OLAP services, which can be accessed by the Excel pivot table functionality, but you will need both SQL Server and Office.
Related Q&A from Kurt Thearling
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.