Page 105 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes A database dimension is a collection of associated objects, called attributes, which can be
used to supply information about fact data in one or more cubes.

You can add a named calculation to a table in a data source view. The expression appears
and behaves as a column in the table.
A parent-child dimension is based on two dimension table columns that together define
the lineage relationships among the members of the dimension.

6.7 Keywords

Data Source Reference: A data source reference is an association to another Analysis Services
project or data source in the same solution.

OLTP (Online Transaction Processing): Online transaction processing, or OLTP, is a class of
information systems that facilitate and manage transaction-oriented applications, typically for
data entry and retrieval transaction processing.
Oracle: The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an
object-relational database management system produced and marketed by Oracle Corporation.
Parent-child Dimension: A parent-child hierarchy is a hierarchy in a standard dimension that
contains a parent attribute.

RDBMS: RDBMS stands for Relational Database Management System. RDBMS data is structured
in database tables, fields and records.
SQL: SQL (Structured Query Language) is a special-purpose programming language designed
for managing data held in a relational database management system (RDBMS).

6.8 Review Questions

1. What are the steps of creating data source?
2. Write down the process of creating data source using the data source wizard.
3. What are the types of data sources?
4. Write down the steps in creating a data source view.
5. Give explanation of modifying the data view.

6. Explain about the time dimension options in SQL server 2008 Analysis Services.
7. What are parent-child dimensions?
Answers: Self Assessment

1. True 2. True
3. True 4. False
5. True 6. Maximize
7. Zoom 8. Auto Hide
9. DataView 10. Attributes
11. SSDT 12. Dimension Wizard
13. True 14. True
15. True

100 LOVELY PROFESSIONAL UNIVERSITY