The
Back button or the left navigation bar can be used to return to the appropriate page to
change any of the selected options. Clicking the Finish button will close the wizard
and load the dimension data from the selected source. The display is automatically
changed to dimension workspace where the newly loaded members can be reviewed.
After all the dimension members are loaded from a data source, the dimension can
be saved or checked in. Checking in will automatically save the dimension data to
the PPS Planning system.
Load Members from CSV Files The third option for loading dimension data is to load
members from a Comma Separated Value (CSV) file. Loading dimension members
from a CSV file is used in situations where the modeler working with the Planning
Business Modeler client tool has to load a dimension that has a large number of
members that are fairly static, the dimension data is obtained from an external source
like an ERP system in a flat file, and the modeler does not have the know-how or
permission to load the data into one of the data source databases defined in the PPS
Planning Server. The user defined Employee dimension is selected to demonstrate
loading of dimension data from a CSV file in this chapter.
The first step in loading dimension data from CSV file is to click the link Load
Members from the Dimension Tasks pane after the Checking Out the Employee
dimension. This will open the Select Member Source page in the Load Members
Wizard, as shown in Figure 7-19.
Pages:
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327