Open BIDS and create new SSAS Project

1
(No Transcript)
2
(No Transcript)
3
Open BIDS and create new SSAS Project
4
Right Click on Data Source and click on New Data
Source
5
Data Source Wizard loads
6
Click on New to add a Data Source
7
Select your source database
8
Define Connection
9
Wizard Complete
10
You now have a data source
11
Adding a Data Source View
12
Start Data Source Wizard
13
Select Data Source
14
Select Dimensions and Fact Tables
15
Complete Data Source Wizard
16
You now have a View
17
You now have a layout
18
Add a new Cube
19
(No Transcript)
20
Select Build Method
21
Select View
22
(No Transcript)
23
Select the correct facts and dimensions
24
Select measures needed
25
Detect Hierarchies
26
Review Dimensions and Hierarchies
27
Cube Wizard Completed
28
We now have Cube and Dimensions
29
Check Project Settings
30
Process Cube
31
Process of Processing Cube
32
Deploy Cube to SSAS