Creating Simplest Cube using Adventures Works...

Step 1: Open the Business Intelligence Development Studio - BIDS and Select the Project called Analysis Services Projects as shown below in the Screenshot and Press Ok Button at the Bottom After providing the Exact Name and Location to be stored.

Step 2: Right click on Datasource Folder for Creating new Datasource as shown below

Step 3: Select the respective Server Name and the Database needed for Creating Cubes. Also test the Connection is perfect by clicking the Test Connection Button at the bottom.

Step 4: Provide the Credentials as the Wizard goes on and Complete the process. Similarly create the Data Source View - DSV for selecting tables from the Database or from the Datasource as shown.

Step 5: Required tables are select to create Cube. For creating simplest Cube, I had added only 4 tables out of which 3 are Dimension table and 1 is Fact. Time Dimension is called as Role Playing Dimension and Geography is called as Reference Dimension which is in Snowflake Format with Customer table.

Step 6:Data Source View is shown as below. Add these Dimension tables into Dimension Folder and Create the Simplest Hierarchies of Countries, States and City as shown below

Step 7: Now process the Dimension using the Processing Methodologies such as Process Full which in turn runs the Process Clear, Process Structure, Process Data and So On.

Step 8: Once the process is done, User's will see the Process Succeeded Messages with No Warnings and Errors. Close it and Try to browser from Dimension Browser as shown below.

Step 9: Data appears correctly for English Occupation as Distinct Data similar to Adventure Works Database. Now Create the Cube using the Fact table and access the Data by slicing and dicing the Data.