Page 123 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Customer with Customer_Name as the member name column and Customer_ID as
the member key column

Retail Stores, based on the table Retail_Stores and containing these levels from highest to
lowest:
(All)

Retail Store with Retail_Store_Name as the member name column
and Retail_Store_ID as the member key column
Products, based on the table Products and containing these levels from highest to lowest:

(All)
Product Category with Product_Category as the member name column and the
member key column

Product with Product_Name as the member name column and Product_ID as the
member key column
The cube’s fact table Sales is:

Table 8.2: Fact Table Sales

Transaction_ID Customer_ID Product_ID Retail_Store_ID Sales_
Amount
1 1 1 1 300
2 1 1 1 250
3 1 1 1 250
4 1 2 1 100
5 1 4 1 700
6 2 1 2 290
7 2 2 2 90
8 2 3 3 510
9 3 1 4 350
10 3 2 3 110
11 4 3 4 550
12 4 4 4 750

Source: http://msdn.microsoft.com/en-us/library/ms365396.aspx
Cube’s dimension tables Customers, is:

Table 8.3: Dimension Table Customers
Customer_ID Customer_Name Customer_Address_ Customer_Address_
Line_1 Line_2
1 A 1 A Street Aville, AA 55555
2 B 2 B Street Bville, BB 55555
3 C 3 C Street Cville, CC 55555
4 D 4 D Street Dville, DD 55555

Source: http://msdn.microsoft.com/en-us/library/ms365396.aspx

118 LOVELY PROFESSIONAL UNIVERSITY