Calendar hierarchy goes from year
to quarter to month to day, so clicking on the bars follows this path of drilling down.
There are other capabilities of the Analytic Chart, which will be discussed in Chapter 6
when the analysis piece of PerformancePoint Server is covered.
Creating an Analytic Grid is nearly identical to creating an Analytic Chart. One
of the primary differences is that rather than a Series panel, in this case there is a
Rows panel. When building charts, it is not uncommon to place both dimensions and
measures on the Columns, and other dimensions on the rows. Additional hierarchies
can be added to the background if they will be used to filter once this report is added
to a dashboard. The Analytic Grid will be discussed in greater detail in Chapter 6.
Creating a Trend Analysis Chart
One special type of report is a Trend Analysis Chart, often just called a Trend Chart.
The Trend Chart trends a KPI on a scorecard. This trend is for historical data but can
also be used to create a forecast using one of the data mining algorithms built into
120 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
Analysis Services. Note that more than one KPI can be used but each KPI will get
its own Trend Chart. The Trend Chart still uses the Office Web Components, but its
functionality cannot be reproduced currently using the Analytic Chart.
There is a server property setting in Analysis Services that must be set in order for
this feature to work.
Pages:
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178