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 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 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