SSAS:Beginner

Refer Source VideoSSAS Tutorial for Beginners Basics of multidimensional cube video

visual studio-project-Analyis Services Multidimensional Data

Star schema ( Fact - Dimension)
Solution Explorer

Data Sources:
  - new connection Database:
Data Source Views:
  - source the Data source : choose the tables
Cubes:
  -New Cube - use existing tables - Fact Table ( Measures ) -Dimensions
Dimensions:
  - creates the Dimensions on the above step
     ( add all that attribute reqd.)
Mining Structure
Roles


Properties:Deployment
Right click : Process

Deployed the Metadata

 Click on Run button it completely deploys to the server instance.

Control Panel- Service- Sql Server Browser start



Data  source:choose the user credential
Particular login does not have access to the database.


Test:Analysis Services