Loading dimension members from a
data source is recommended for dimensions that have a large number of members
that are fairly static, and where the dimension data is readily available from other
sources including an existing data warehouse. The Entity dimension is selected to
demonstrate loading of dimension data from a data source in this chapter.
The first step in loading dimension data is to Check Out the Entity dimension.
After checking out the dimension, select the Member Maintenance tab in the
dimension workspace. From the Dimension Tasks pane on the right side, click the
first link??”Load Members??¦ to display the Select Member Source page in the Load
Members Wizard, as shown in Figure 7-19. Select the Load members from source
option in this page. Associated with this option is a drop-down list titled Source,
which will show a list of all the data sources that are associated with the model site
in the PPS Planning Server. Select the Source named Corp_DataMart (defined earlier
in this chapter) as the data source, as shown in Figure 7-19.
The next page in the Load Members Wizard is the Specify Dimension Properties
page, as shown in Figure 7-20. The Source Dimension: drop-down box will list all
Figure 7-19 There are two options for loading data from external data sources while
using the Load Members Wizard.
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 249
the Tables and Views that were selected while defining the Data Source Connection
in Planning Administration Console, as shown in Figure 7-8.
Pages:
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325