Figure 7-8 shows the Create a Data Source
Connection dialog box with values entered in it. Clicking on the Show Tables/Views
button will show all the available tables and views from the selected data source. The
tables and views that need to be exposed in Planning Business Modeler should be
moved into the Selected Tables/Views box by selecting items in the Available Tables/
Views box and clicking the > button. Clicking the >> button will move all tables
Figure 7-8 Commonly used external Data Sources include Enterprise Data Warehouses,
which contain dimension and fact data that can be used by PerformancePoint
Server Planning Server.
C h a p t e r 7 : P l a n n i n g M o d u l e i n P e r f o r m a n c e P o i n t S e r v e r 231
and views. If no table or view is specified in the Selected Tables/Views box, the data
source will not be available in the Planning Business Modeler. Click OK to close the
dialog box, and to save the Data Source connection information in the system.
The Data Destinations link on the left pane of the Planning Administration
Console page is used to manage the external data destination connections for the
PerformancePoint Server Planning Server. A data destination connection creates or
registers a database on the same server that contains the Application database. Data
destination connections define locations where data will be exported when outbound
rules are run. The outbound rules enable the plan data (forecast, budget, and so on)
from the model in PerformancePoint Server Planning system to be exported to an
outbound database.
Pages:
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302