When a dimension is synchronized with the staging area for the first
time, it creates a table named D_
in the Staging Database and
populates the table with all the members that are currently defined for that dimension
in the PPS Planning Application. In our example, synchronizing the Account
Figure 7-22 The before and after of populating the Member of Dimension data type in
a dimension.
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 253
dimension will create dbo.D_Account table in the Budget_ StagingDB database. The
default NONE member from the Account dimension is also loaded into that table.
The Account dimension members from any external source can be loaded into
D_Account table using ETL process and/or tools such as SQL Server Integration
Services (SSIS). As always, the fields Label and Name are required fields. Another
required field that should be populated by the ETL process in the case of any dimension
is the BizSystemFlag. Any other required field, such as the AccountTypeMemberId in
the case of Account dimension, should also be populated in the Staging Database before
data can be loaded from the Staging Database to the Application Database.
When you are loading dimension data from the staging database to the application
database in Planning Business Modeler, all changes to dimension data in the
staging database will be integrated into the application database. This includes new
dimension member rows, updated dimension member rows, and deleted dimension
member rows.
Pages:
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331