"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

August 02, 2011

SSAS Tutorial - Part I

I referred to MSDN SSAS Tutorial. It is very good. There are not many snapshots for steps in the tutorial. Ten lessons provided are a very good start for learning SSAS. I have covered first 3 chapters to start with. I am summarising few steps and notes based on my learning.

Lesson 1 - Defining Data Source and View
  • Creating Data Source and Data Source Views we have checked in earlier examples
  • Modifying the Fact and Dimension tables from default names is new learning in this lesson

Lesson 2 - Defining and Deploying Cube

Defining Dimension Steps
Creating Date Dimension and Specifying Attributes

Step 1 - Select the Date Dimension

Step 2 - Change Attribute type as shown below

Dimension Wizard
  • Existing Table Date
  • Date Key
  • Full Date Alternate Key - Attribute - Month - Regular - Date - Calender - Date
  • English Month Name rename to Month
  • Calendar Quarter Attribute to Quarter
  • Calendar Year Attribute to Year
  • Calendar Semester Attribute to Half Year
Step 3

Defining a Cube

Step 1 - Adding Measure Tables

Step 2 - Selecting Measures

Adding Attribute to Dimensions

Step 1 - Under Dimension Structure drag and drop attributes as shown in below snapshot. Adding Product Attributes

Step 2 - Adding Customer and Geography dimensions

Lesson 3 - Modifying Measures 

Step 1 - Adding more measure in Cube Structure. Attributes added in measures from Fact Table. Properties changing names marked in below snapshot

Summary - This chapter focusses on
  • Adding Named Calculation
  • Creating Hierarchy
Step - Creating Hierarchy

Step - Adding Named Calcuation

Step - Mapping Customer Attribute to Customer Name

Browsing Cube

Display folder names created in previous steps now shows in the Cube Browser Left Side Display Areas

HIERARCHY Created also listed in below snapshot

Next list of posts will be for KPIs, Calculations.....

Happy BI Learning !!!

No comments: