Page 133 - DCAP606_BUSINESS_INTELLIGENCE

Deepak Mehta,Lovely Professional University
Business Intelligence

Notes Unit 9: Advanced Dimensional Design

CONTENTS
Objectives
Introduction

9.1 Creating Dimensions
9.2 Build an Account Dimension to Support Financial Analysis
9.3 Interacting with a Cube

9.3.1 Implementing Actions
9.3.2 Creating Standard Actions
9.3.3 Creating Drillthrough Actions
9.3.4 Linking to Reporting Services Reports
9.4 Summary

9.5 Keywords
9.6 Review Questions
9.7 Further Readings

Objectives

After studying this unit, you will be able to:

Discuss Creating Dimensions
Explain Build an Account Dimension to Support Financial Analysis
Interpret interacting with a Cube

Introduction

In this unit, you will learn about advanced dimensional designs. Multiple hierarchies can be
created for a dimension to provide alternate views of dimension members. The account dimension
and its associated rules enable you to create and maintain a chart of accounts for various financial
models. Here, you will learn about creating dimensions. You will also be able to build an
account dimension to support financial analysis. Each base schema design technique brings
limitations and implications for aggregate design. Finally, you will learn about interacting
with cubes. In this the key focus will be on implementing actions, creating standard actions and
creating a drillthrough action.

9.1 Creating Dimensions

Multiple hierarchies can be created for a dimension to provide alternate views of dimension
members.

Example: A time dimension that has two hierarchies can comprise of a normal calendar
view and a fiscal calendar view.

128 LOVELY PROFESSIONAL UNIVERSITY