If you require low granularity (Activity, Daily) for a large number of projects, you may want to use multiple Stars. Multiple Stars will help decrease the run time and separate data into different ETL processes. To separate projects, you need to add a defining characteristic (portfolio, project code assignment, etc.) to the project in P6. The following diagram shows how the different Star environments will connect to their own OBI environment.
To set filters for the Star instance:
The filter will set a Select statement to retrieve the project ID’s for only the projects you want in this Star. This can be any criteria discussed above such as portfolio or project code assignment. This filter mechanism overrides the default process of gathering all the project ID’s for each project in the Extended Schema that has Enable Publication set.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014