Data Analysis

This excercise should develop a simple analysis cube.

Before beginning we need to add the local service user to the AdventureworksDW Database. Open the security folder for AdventureworksDW and right click on Users.
Select New User. In the login dialog box click on the button by logins and find the local service login. Give the user a name. In the database roles click on the datareader role. Click ok.

Creating a cube

1. Open the Business Intellegence studio
2. Choose FILE /New Project
3. Choose an Analysis Service Project
4. In the Solution Explorer right click on Data Sources
5. Choose New Data Source
6. Next
7. Click the New ...




8. configure the connection



9. Next. Choose Use Service Account



10. Next/Finish
11. In the Solution Explorer Right click on the Data Source View Folder.
12. Choose a new data source view
13. Next
14 Add all the tables and click next



15. Next. Review the tables. Finish
16. In the Solution Explorer right click on Cubes and choose New Cube
16. Next
17. Choose "Use existing tables"
18. Next. Select "FactInternetSales" Next
19. Accept what's there.
20. Next, Next, Next
21. Finish.
22. Right click the cube and select process.
23. A dialog says the cube seems out of date etc, say yes
24. Click Run
25. If all goes well and the cube deploys click close and close again
26. Click Browser
27. Drag fields onto the cube as shown in the illustration below



28. Feel free to add or subtract other fields from the cube