Multiple Star Environments

Previous TopicNext TopicContents

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.

multiple_stars

To set filters for the Star instance:

  1. Follow the installation instructions in the P6 Analytics and Star Database Installation and Configuration Guide.
  2. Define your filters as described in the P6 Analytics and Star Database Installation and Configuration Guide.

    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