Page 116 - DCAP606_BUSINESS_INTELLIGENCE
P. 116
Unit 7: Creating Cube
6. In similar way, expand, United States, Order date, Customer and other headings as required. Notes
Figure 7.10 shows Internet sales by region and product line for the month of February, 2002.
Figure 7.10: Internet sales by region and product
line for the month of February, 2002.
Self Assessment
Fill in the blanks:
9. After you deploy a cube, ............................ is viewable on the Browser tab in Cube Designer,
and .............................. is viewable on the Browser tab in Dimension Designer.
10. The Browser tab includes two panes to the right of the metadata pane: the upper pane is
the ............................., and the lower pane is the ...................................
Case Study Building a Data Cube
T his example uses sales figures from XYZ Co., which makes many kinds of widgets.
For each sales transaction, we know four pieces of data:
Which types of widget were involved (style, colour, size and so on)
Store or sales agent
Sales amount
Geographic region or territory
In a real-world situation, we would also know many other data items, including:
Quantity
Contd....
LOVELY PROFESSIONAL UNIVERSITY 111
