SSAS Tutorial

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

CHAPTER 3: DEFINING AND DEPLOYING A CUBE
TASK 2 – DEFINING A CUBE.
To add attributes   12
TASK 6 – BROWSING THE CUBE.
To browse the deployed cube

CHAPTER 4: MODIFYING MEASURES, ATTRIBUTES AND HIERARCHIES
TASK 1 – MODIFYING MEASURES      
TASK 3 – MODIFYING THE PRODUCT DIMENSION        

CHAPTER 5: DEFINING ADVANCED ATTRIBUTE AND DIMENSION PROPERTIES
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

No comments:

Post a Comment