SQL Server - SQL Server Analysis Services (OLAP)

About

Data Mining and OLAP cube.

Powerpivot: Excel engine for cube connection/client ?

Tool

Builder

To develop cubes, you use:

  • SQL Server Data Tools

Front-end

  • Microsoft Office
  • Microsoft SharePoint

Service

SSAS is a service that host multidimensional databases.

These databases contain:

Installation

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

Excel

Cubevalue function


Powered by ComboStrap