Page 98 - DCAP606_BUSINESS_INTELLIGENCE

Unit 6: Business Intelligence Project

These columns can be used to define a parent-child dimension that contains the following Notes
member hierarchy.

Figure 6.5: Sample Member Hierarchy

Source: http://i.msdn.microsoft.com/dynimg/IC44843.gif
Both columns must have the same data type. Both columns must be in the same table.
When you define a parent-child dimension, you can also select a third column to provide
member names, which are displayed to end users as they browse cubes. The depth of a parent-
child dimension can vary among its hierarchy’s branches.
You can use the Dimension Wizard to create parent-child dimensions. After you create a parent-
child dimension, you can edit it in Dimension Editor (if the dimension is shared) or Cube Editor
(if the dimension is private).

Task Make report on application of business intelligence and planning in midsize
companies.

Self Assessment

State whether the following statements are true or false:
13. A parent-child dimension is based on two dimension table columns that together define
the lineage relationships among the members of the dimension.
14. When you define a parent-child dimension, you can also select a third column to provide
member names, which are displayed to end users as they browse cubes.

15. You can use the Dimension Wizard to create parent-child dimensions.

Case Study Managing Data Sources for Input to Data
Warehousing and Business Intelligence

ata warehousing and business intelligence effort is only as good as the data that
is put into it. The saying “Garbage In, Garbage Out” is all too true. A leading
Dcause of data warehousing and business intelligence project failures is to obtain
the wrong or poor quality data.
Contd....

LOVELY PROFESSIONAL UNIVERSITY 93