Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 833

sent by Data Analyzer, this topic will grow to the size of a New York City
phone book. We leave this as an exercise for the reader: to analyze the MDX
queries and understand the mapping between the query and the value shown
in the view. To identify the MDX query sent to the server, you can use SQL
Profiler and create trace events. Please refer to Chapter 13 on how to create
traces to Analysis Services.

Figure 15-58

Use of correct terminology is critical in business intelligence;
saying one thing when you mean another doesn't help mat-
ters. Drill down versus Drill-through is the poster child for in-
accurate use of terminology. To drill down means to continue
opening lower levels of dimension members, thereby
"drilling" into lower levels of data granularity. Drill-through has
a completely different meaning; to drill-through means to ac-
cess the fact (detail) data corresponding to a cell in the cube
which you learned in Chapter 9 . Nobody who has dutifully
read this topic should ever confuse the two.

Important