From this drop-down
list select the table or view that contains the dimension data. The DimEntity table is
selected here for the purpose of the examples in this chapter.
The next step is to map the PPS Planning Application dimension properties to
the fields in the source table or view. The Application dimension properties are
listed under the column titled Target dimension property to the left of the Specify
dimension properties page. Clicking on the down arrow button to the right of each
row in the Source dimension property column (to the right side of the page) will
display the list of fields available in the selected source table or view. Using these
buttons on each row, map the Application dimension properties to the appropriate
fields in the source table or view. The Label and Name are required fields and
should be mapped to data source fields. The optional fields can be mapped if data
is available, or they can be left unmapped by selecting
in the Source
dimension property column. The completed mapping for the Entity dimension is
shown in Figure 7-20.
Figure 7-20 The PPS Application dimension properties should be correctly mapped to
the data source fields while using a previously defined Data Source Table or
View.
250 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
The last page in the Load Members Wizard is the Review and Load page. Here
the developer can review the dimension and property mapping information.
Pages:
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326