Recall that the monitoring
servers??™ predecessor, Business Scorecard Manager, did not natively understand
Analysis Services 2005 KPIs. Clearly, PerformancePoint Server can take advantage
of KPIs already built into the cube, but it can also use measures in the cube to create
KPIs on the fly. There are advantages to each approach, but KPIs are often best built
into Analysis Services cubes. This keeps different developers from creating the same
KPI with different formulas on different scorecards. Remember that one purpose
of BI is to have a single version of the truth so pushing KPIs into the cube helps
enforce a standard definition for that KPI. On the other hand, it??™s unlikely that a cube
will ever have all the KPIs that will ever be needed, so PerformancePoint Server
includes the capabilities to create KPIs based on the measures in the cube.
Depending on whether your choice is to use KPIs from the cube or build KPIs in
Dashboard Designer from measures in the cube, the next screen of the wizard will
look slightly different. Figure 5-8 shows both options; the top part of the screen
shows what happens if the developer chooses to create KPIs from cube measures,
while the bottom half shows the screen if the developer wants to use existing KPIs
that are built into the cube. Reusing existing KPIs is relatively simple, as just
clicking the Import checkbox beside each KPI will bring it into the scorecard. The
more complicated approach is to now build each KPI in the Dashboard Designer
from the measures in the cube.
Pages:
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145