Databases Reference
In-Depth Information
Figure 15-57
9. Data Analyzer provides you a way to visualize data in Bar View, Grid
View, or Pie Chart View. For each of the dimensions. if there is not
sufficient space to show the results in the Pie Chart view, Data Ana-
lyzer will default to Bar view. To see the effect of the Grid View and
Pie Chart views close the windows showing hierarchies Organiza-
tions and Departments. Go to the Date (Calendar) hierarchy. Click on
the Pie Chart view option at the bottom of the window. To do so, hov-
er the mouse cursor over the "eye" (as shown in
Figure 15-58
) at the
bottom left of the corresponding window. Similarly click on the Grid
view for the Product (Product Categories Hierarchy). You will now
see the data displayed in the Pie Chart view and Grid views as
shown in
Figure 15-58
.
We have introduced you to some of the basic functionalities available in Data
Analyzer. You have likely noticed the flexibility and power of analyzing data
from within Data Analyzer from this brief overview. We recommend you refer
to the product documentation for an in-depth understanding of the capabilities
provided by Data Analyzer.
Data Analyzer dynamically creates MDX queries for each of the operations
you perform in the view. Data Analyzer creates Sets and calculated members
for querying the data. We have not detailed the MDX queries sent to the serv-
er because the Sets and calculated members have dynamically generated
names that are lengthy, and because multiple MDX queries are sent to the
Analysis Services for each user action. If we start explaining each MDX query
Search WWH ::
Custom Search