Populate Data Sources with Filtered Project Data

Previous TopicNext TopicContents

Star supports multiple P6 data sources. If you just want to populate multiple data sources with filtered project data, you will need to do the following:

  1. Run this sql:

    CREATE OR REPLACE FORCE VIEW STAR_PROJECT_VIEW_1

    AS

    SELECT OBJECTID FROM project WHERE OBJECTID NOT IN (4514,4564,4664);

    commit;

  2. Go to star_home>\star\res and add a line to staretl.properties specifying the filter to use for each data source:

    For example:

  3. Run the staretl for that data source.

    For example:

    staretl.bat “-s1” would apply to the filter for ds1.

When you run the staretl and multiple data sources are specified in the configuration file, the staretl populates the data sources with "filtered" project data as per the properties above.

Related Topics

Post Installation Administrative Tasks

Securing the staretl.properties File

Clearing the Data for Star

Refreshing the Data for Star

Creating a Filtered Star

Scheduling the Star Database Update

Manually Launching the Star Database Update Process

History Settings for P6 Reporting Database 3.2

Using Metadata

Backing up the Star Database Nightly



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014