Page 144 - DCAP606_BUSINESS_INTELLIGENCE

Unit 9: Advanced Dimensional Design

Cube Designer: The Cube Designer in Business Intelligence Development Studio (BIDS) includes Notes
an activity tab.
Multidimensional Expression sign (MDX): Multidimensional Expressions (MDX) is a query
language for OLAP databases, much like SQL is a query language for relational databases. It is
also a calculation language, with syntax similar to spreadsheet formulas.

URL actions: A URL action is a hyperlink that points to a Web page, file, or other web-based
resource outside of Tableau.

9.6 Review Questions

1. What is a data dimension?

2. Why do we create the data dimensions?
3. Discuss the process for creating a dimension with a single defined hierarchy using the
dimension wizard.

4. Explain the steps for creating a dimension with additional defined hierarchies using the
dimension wizard.
5. Describe the pre-defined properties of account dimension members.

6. Write about the user modifications in the account dimension.
7. How do we implement the actions in OLAP?
8. How do we create a URL action?

9. Write down the process for creating drillthrough actions.
10. Discuss how to configure internet explorer security to allow reporting services
administration?

Answers: Self Assessment

1. Schema 2. Dimension Wizard or Dimension Editor
3. True 4. True
5. Online Analytical Processing (OLAP) 6. Cube facts

7. Activity tab 8. Drillthrough
9. Relational database 10. Report

9.7 Further Readings

Books Carlo Vercellis (2011). “Business Intelligence: Data Mining and Optimization for Decision
Making”. John Wiley & Sons.
David Loshin (2012). “Business Intelligence: The Savvy Manager’s Guide”. Newnes.
Elizabeth Vitt, Michael Luckevich, Stacia Misner (2010). “Business Intelligence”.
O’Reilly Media, Inc.

LOVELY PROFESSIONAL UNIVERSITY 139