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
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.....
More Reads
Introduction to Data Warehouse - BI
Introduction to Data Warehouse - BI
Happy BI Learning !!!
No comments:
Post a Comment