Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Three types of OLAP storage schemes in Analysis Services are compatible with Analysis Cubes for Microsoft Excel

Three types of OLAP storage schemes in Analysis Services are compatible with Analysis Cubes for Microsoft Excel

INTRODUCTION

This article gives an overview of the three types of OLAP storage schemes that are compatible with Analysis Cubes for Microsoft Excel in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains. These OLAP storage schemes are available in Microsoft SQL Server Analysis Services.

↑ Back to the top

More Information

The following is an overview of the three types of OLAP storage schemes:
  • Multidimensional OLAP (MOLAP)
    Data is stored in and retrieved from cube structures that are separate from a relational database. This OLAP has the fastest query performance for users.
  • Relational OLAP (ROLAP)
    Data is stored in and retrieved from a relational database. This OLAP has the slowest query performance for users.
  • Hybrid OLAP (HOLAP)
    Data is stored in and retrieved from a combination of multidimensional cube structures and relational database tables. The query performance of this OLAP is slower than Multidimensional OLAP but faster than Relational OLAP.

↑ Back to the top

Keywords: kbmbspartner, kbinfo, kbmbsmigrate, kbarchive, kb

↑ Back to the top

Article Info
Article ID : 916683
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 82