Page 97 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes To add a named calculation
1. Open the data source view by double-clicking it in the Data Source Views folder in Solution
Explorer.

2. In the Tables pane, right-click Date, and then click New Named Calculation.
3. In the Create Named Calculation dialog box, type SimpleDate in the Column name box,
and then type the following DATENAMEstatement in theExpression box:

DATENAME(mm, FullDateAlternateKey) + ‘ ‘ +
DATENAME(dd, FullDateAlternateKey) + ‘, ‘ +
DATENAME(yy, FullDateAlternateKey)
4. Click OK, and then expand Date in the Tables pane. On the File menu, click Save All.

5. In the Tables pane, right-click Date, and select Explore Data.
6. Review the last column in the Explore Date Table view. Close the Explore Date Table view.

Self Assessment

Fill in the blanks:
9. We can use the ................................. to add, delete, or modify rows of data in the table.

10. A database dimension is a collection of associated objects, called................................., which
can be used to supply information about fact data in one or more cubes.
11. Uses the Dimension Wizard in ................................. to create a database dimension in a
Microsoft SQL Server Analysis Services project.
12. In Microsoft SQL Server Analysis Services, you can use the ................................. in SSDT to
create a time dimension when no time table is available in the source database.

6.5 Parent-Child Dimensions

A parent-child dimension is based on two dimension table columns that together define the
lineage relationships among the members of the dimension. One column, called the member
key column, identifies each member; the other column, called the parent key column, identifies
the parent of each member.

Example: In the following Employee table, the column that identifies each member
is Employee_Number. The column that identifies the parent of each member
is Manager_Employee_Number.

Table 6.2: Sample Employee Table

Source: http://i.msdn.microsoft.com/dynimg/IC553.gif

92 LOVELY PROFESSIONAL UNIVERSITY