Developing an OLAP Cube

Developing an OLAP Cube Overview Using BIDS, after the DSV is developed, the next step is to create dimensions. Dimensions...

Creating Star Schema

Creating a Star Schema Using a Data Source View Overview A data warehouse or data mart from where we would source our...

Create New Project

Creating a SSAS Project Overview To start development, we need to create a new SSAS project using Business Intelligence...

Installing Sample Database

Installing AdventureWorks Sample Database Overview AdventureWorks is the sample database available from Microsoft for...

Getting Started

Creating a Sample SSAS Project and Cube Overview Data in Online Transaction Processing (OLTP) systems is suited to support...

SSAS Tutorial Overview

SQL Server Analysis Services (SSAS) Overview SQL Server Analysis Services (SSAS) is the technology from the Microsoft...