Page 146 - DCAP606_BUSINESS_INTELLIGENCE
P. 146
Sartaj Singh, Lovely Professional University
Unit 10: Retrieving Data from Analysis Services
Unit 10: Retrieving Data from Analysis Services Notes
CONTENTS
Objectives
Introduction
10.1 Creating Perspectives
10.1.1 Create a Perspective
10.2 Multidimensional Expressions (MDX) Queries
10.2.1 SELECT Statement Syntax
10.2.2 SELECT Statement Example
10.3 Excel with Analysis Services
10.3.1 Connecting Excel Client to Analysis Services Environment
10.4 Summary
10.5 Keywords
10.6 Review Questions
10.7 Further Readings
Objectives
After studying this unit, you will be able to:
Provide insight into creating perspectives
Explain the Multidimensional Expressions (MDX) queries
Discuss the usage of Excel with analysis services
Introduction
Your cube comprises numerous dimensions and measures from some subject areas: sales, finance,
output, and inventory. It can assist as a source of information for multiple workgroups or
agencies across your association. Although this centralization is beneficial for users, application
developers, and IT administrators, it might be difficult for users to find their way to the data
they need. To help make your cube simpler to comprehend and navigate, you can create
perspectives that limit the number of dimensions, calculations, actions, and KPIs that users see
when they are browsing or querying a cube. A perspective allows you to create a view of a
subset of a cube that can be more easily comprehended by users. This unit will provide you an
insight into creating perspectives. You will learn about Multidimensional Expression (MDX)
queries. Finally, you will learn about connecting Excel client to Analysis Services environment.
10.1 Creating Perspectives
A cube may contain multiple viewpoints. Generally each viewpoint displays a subset of the
cube that is related to a widespread subject area or that is needed by a group of users. To describe
and visualize applications, a viewpoint appears just like a cube. Although, it is important to note
that you cannot request security to a viewpoint.
LOVELY PROFESSIONAL UNIVERSITY 141
