SQL Server - SQL Server Analysis Services (OLAP)

> Database > SQL Server - SQL Server Analysis Services (OLAP)

1 - About

Data Mining and OLAP cube.

Powerpivot: Excel engine for cube connection/client ?

2 - Tool

2.1 - Builder

To develop cubes, you use:

  • SQL Server Data Tools
Advertising

2.2 - Front-end

  • Microsoft Office
  • Microsoft SharePoint

3 - Service

SSAS is a service that host multidimensional databases.

These databases contain:

4 - Installation

Multidimensional analysis is supported in SQL Server Standard, Business Intelligence, Enterprise, Developer, or Evaluation edition

5 - Excel

Cubevalue function

Advertising