PerformancePoint Monitoring
Server is hosted through Internet Information Services (IIS) so it uses application pools to run
in. Each application pool can be set to run under the context of an existing service, such as the
network service, or an actual user name and password. Therefore, the cube must have a role that
grants permissions to the user or service under which the application pool runs. Another option
is to configure the server to pass the current user credentials through to Analysis Services. These
options will be discussed in greater detail in Chapter 8 in the section on security.
The final option on the Summary tab is Cache Settings. By default, PerformancePoint
Server will get data from Analysis Services and then cache that data for 10 minutes.
After ten minutes, PerformancePoint Server will invalidate the cache and the next
Figure 5-4 This is the dialog box showing the creation of a new Analysis Services data
source. The same three fields on this dialog box will be seen many times
when working with the Dashboard Designer wizards
88 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
query will reconnect to the cube to retrieve data. If this is a cube that is updated less
frequently, this time will be extended. For organizations doing real-time or near-realtime
BI, shortening this cache internally might make sense. Figure 5-5 shows the
Summary page filled out to connect to the Adventure Works cube in the Adventure
Works DW database.
Pages:
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139