Select the Load members from a CSV file on this
page and provide the location of the file containing the dimension member data in
the Location text box.
The dimension member data should be provided in a Comma Separated Value file
format. The CSV file should contain columns headers in the first row and the first
column header should be titled Label. This column should contain the dimension
member labels, which is the primary identifier of objects throughout the system. The
Name column is also required, and the column header must be titled Name exactly.
If the optional description column is included in the CSV file, the column headers
must be titled Description. Figure 7-21 shows a sample CSV file that is loaded to the
Employee dimension for the purpose of the examples in this chapter.
The last page in the Load Members Wizard is the Review and Load page. Here
the modeler can review CSV file path. The Back button or the left navigation bar
can be used to return to the first page to change the file path if needed. Clicking
the Finish button will close the wizard, and load the dimension data from the CSV
file. The display is automatically changed to dimension workspace where the newly
loaded members can be reviewed. After all the dimension members are loaded from
the CSV file and verified, the dimension can be saved or checked in. Checking in
will automatically save the dimension data to the PPS Planning system.
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 251
You may remember from the earlier section on Dimension Member Property
that we have created a referential relationship between the Employee dimension
and Entity dimension, with Employee being the referencing dimension and Entity
being the referenced dimension.
Pages:
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328