Transcription of Introduction to SQL Server Analysis Services - …
1 Introduction to SQL Server Analysis Services 1 OLAP Starting an Analysis Services Navigating the Management Retrieving Retrieving a Single, Summarized Rotating Specifying Tuple Avoiding Retrieving Multiple, Summarized 16 Specifying Exercise 1: Displaying Data from a Single 19 Multiple Using the Default Exercise 2: Displaying Multiple Measures in One Slicing the 32 Exercise 3: Slicing the Cube by Using the WHERE 37 Exercise 4: Sorting the 42 45 MDX VBA Exercise 5: Calculations, Functions and Introduction to SQL Server Analysis Services Appendix A: Class Data 52 Appendix B: OLAP versus 56 Appendix C: OLTP Data 57 Appendix D: Web Site 61 Appendix E: Solutions to 62 Introduction to SQL Server Analysis Services
