Page 120 - DCAP606_BUSINESS_INTELLIGENCE

Deepak Mehta,Lovely Professional University Unit 8: Advanced Measures and Calculations

Unit 8: Advanced Measures and Calculations Notes

CONTENTS
Objectives

Introduction
8.1 Advanced Measures and Calculations

8.2 Aggregate Functions
8.3 Retrieving Data from a Cube Using MDX Queries
8.4 Calculation Scripting

8.5 Creating KPIs
8.6 Summary
8.7 Keywords

8.8 Review Questions
8.9 Further Readings

Objectives

After studying this unit, you will be able to:

Explain advanced measures and calculations
Discuss aggregate functions
Construct retrieving data from a cube using mdx queries

Learn about Calculation scripting
Explain creating KPIs
Introduction

In this unit, you will learn advanced measures and calculations. The aggregate functions like
SUM, MIN, MAX and COUNT are discussed. It also explains how to use MDX to conditionally
apply formatting to a measure or calculated member and retrieve data from cube. As the unit
progress you will learn about calculation scripts. Finally, you will learn to create Key Performance
Indicators (KPIs) that combine expressions and graphics for actual, target, status, and trend
values.

8.1 Advanced Measures and Calculations

The focus of this is the utilization of advanced methods of exploring and surfacing OLAP cube
data using Multidimensional Expression Language (MDX), both in the Enterprise Guide viewer
and via the PROC SQL interface to OLAP. Before moving to the advanced content, a brief review
of OLAP principles and terminology is necessary to provide some context. Since cube navigation
within the Enterprise Guide viewer plays an integral part in gaining the MDX knowledge
necessary for advance OLAP cube data manipulation, it too will be reviewed.

LOVELY PROFESSIONAL UNIVERSITY 115