SSAS Tutorial

TUTORIAL OBJECTIVE

OBJECTIVES                

CHAPTER 2: DEFINING A DATA SOURCE VIEW WITHIN AN ANALYSIS SERVICES PROJECT

TASK 1 – CREATING ANALYSIS SERVICES PROJECT

TASK 2 – DEFINING A DATA SOURCE

TASK 3 – DEFINING A DATA SOURCE VIEW

TASK 4 – MODIFYING DEFAULT TABLE NAMES

CHAPTER 3: DEFINING AND DEPLOYING A CUBE

TASK 1 – DEFINING A DIMENSION

TASK 2 – DEFINING A CUBE.

TASK 3 – ADDING ATTRIBUTES TO DIMENSIONS

To add attributes   12

TASK 4 – REVIEWING CUBE AND DIMENSION PROPERTIES

TASK 5 – DEPLOYING ANALYSIS SERVICES PROJECT.

TASK 6 – BROWSING THE CUBE.

To browse the deployed cube

CHAPTER 4: MODIFYING MEASURES, ATTRIBUTES AND HIERARCHIES

TASK 1 – MODIFYING MEASURES      

TASK 2 – MODIFYING THE CUSTOMER DIMENSION      

TASK 3 – MODIFYING THE PRODUCT DIMENSION        

TASK 4 – MODIFYING THE DATE DIMENSION  

TASK 5 –BROWSING THE DEPLOYED CUBE

CHAPTER 5: DEFINING ADVANCED ATTRIBUTE AND DIMENSION PROPERTIES

TASK 1- USING A MODIFIED VERSION OF THE ANALYSIS SERVICES TUTORIAL PROJECT

TASK 2- DEFINING PARENT ATTRIBUTE PROPERTIES IN A PARENT-CHILD HIERARCHY

TASK 3- AUTOMATICALLY GROUPING ATTRIBUTE MEMBERS

TASK 4 – HIDING AND DISABLING ATTRIBUTE HIERARCHIES

TASK 5: SORTING ATTRIBUTE MEMBERS BASED ON A SECONDARY ATTRIBUTE

TASK 6- SPECIFYING ATTRIBUTE RELATIONSHIPS BETWEEN ATTRIBUTES IN A USER-DEFINED HIERARCHY

TASK 7: DEFINING THE UNKNOWN MEMBER AND NULL PROCESSING PROPERTIES  

CHAPTER 6: DEFINING RELATIONSHIPS BETWEEN DIMENSIONS AND MEASURE GROUPS

TASK 1-DEFINING A REFERENCED RELATIONSHIP

TASK 2-DEFINING A FACT RELATIONSHIP

TASK 3- DEFINING A MANY-TO-MANY RELATIONSHIP

TASK 4- DEFINING DIMENSION GRANULARITY WITHIN A MEASURE GROUP

CHAPTER 7: DEFINING CALCULATIONS

TASK 1-DEFINING CALCULATED MEMBERS

TASK2- DEFINING NAMED SETS

TASK 3- DEFINING SCOPED ASSIGNMENTS USING SCRIPT COMMANDS

To review the sales amount quota allocations by date and employee

To define the scope for the Sales Amount Quota calculation for fiscal year 2009

To define and test the new Sales Quota calculation for fiscal year 2009

To allocate sales amount quotas to Fiscal Year 2009 Semesters and Quarters

To allocate sales quotas to months

CHAPTER 8: DEFINING KEY PERFORMANCE INDICATORS (KPIS)

TASK 1- DEFINING AND BROWSING KPIS

CHAPTER 9: DEFINING ACTIONS

TASK 1- DEFINING AND USING A DRILLTHROUGH ACTION

CHAPTER 10: DEFINING PERSPECTIVES AND TRANSLATIONS               

TASK 1- DEFINING AND BROWSING PERSPECTIVES

TASK 2- DEFINING AND BROWSING TRANSLATIONS           

CHAPTER 11: DEFINING ADMINISTRATIVE ROLES

TASK 1- GRANTING PROCESS DATABASE PERMISSIONS