Microsoft SQL Server 2000 Analysis Services FAQ
The following section lists some commonly asked questions and answers about SQL Server 2000 Analysis Services.
| Q1: | When should I consider implementing OLAP technology? |
| A1: | Basically, any business process that requires you to analyze (roll up, drill down, and so on) transactional data across a variety of categories is an excellent application of OLAP technology. Loosely speaking, any time you have created an Excel pivot table, you have started to explore the power of OLAP technology. |
| Q2: | What is the difference between relational and multidimensional databases? |
| A2: | The primary difference between a relational database and a multidimensional database is semantics. The true differentiation is the manner ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
