DimEmployeeEmployeeKeyParentEmployeeKeyEmployeeNationalIDAlter...ParentEmployeeNationalI...SalesTerritoryKeyFirstNameLastNameMiddleName

DimProductReorderPointListPriceSizeSizeRangeWeightDaysToManufactureProductLineDealerPriceClassStyleModelName

DimPromotionPromotionKeyPromotionAlternateKeyEnglishPromotionNameSpanishPromotionNameFrenchPromotionNameDiscountPctEnglishPromotionTypeSpanishPromotionType

DimResellerResellerKeyGeographyKeyResellerAlternateKeyPhoneBusinessTypeResellerNameNumberEmployeesOrderFrequencyOrderMonth

DimTimeTimeKeyFullDateAlternateKeyDayNumberOfWeekEnglishDayNameOfWeekSpanishDayNameOfWeekFrenchDayNameOfWeekDayNumberOfMonthDayNumberOfYear

FactResellerSalesProductKeyOrderDateKeyDueDateKeyShipDateKeyResellerKeyEmployeeKeyPromotionKeyCurrencyKeySalesTerritoryKeySalesOrderNumber

Open BIDS and create new SSAS Project

Right Click on Data Source and click on New Data Source

Data Source Wizard loads

Click on New to add a Data Source

Select your source database

Define Connection

Wizard Complete

You now have a data source

Adding a Data Source View

Start Data Source Wizard

Select Data Source

Select Dimensions and Fact Tables

Complete Data Source Wizard

You now have a View

You now have a layout

Add a new Cube

Select Build Method

Select View

Select the correct facts and dimensions

Select measures needed

Detect Hierarchies

Review Dimensions and Hierarchies

Cube Wizard Completed

We now have Cube and Dimensions

Check Project Settings

Process Cube

Process of Processing Cube

Deploy Cube to SSAS