You can combine more than one Extended Schema into a single Star data warehouse, which allows you to have more than one P6 installation with an Extended Schema and be able to view all that data in one Star. For example, if you have a resource, John Smith, working in P6 database 1, you could see a combination of John Smith’s assignments across database 1, 2, and 3. To work, this process requires that the names of resources, projects, or EPS’s match. You can ensure this works by storing the data in the same dimensions and facts and inserting rows with unique row ID's for each data source. This gives you the ability to report on data across all data sources or report on data specific to just one data source.
Note: You cannot run the ETLs for the data sources at the same time. Each additional data source will require a unique installation with its own configuration information. Each installation will have its own staretl. The staretl processes cannot run at the same time because the unified Star will still use the same internal staging tables. If multiple ETL processes were running at the same time, they could overwrite each other in the staging tables and cause failures or data corruption.
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014