Creating a Filtered Star

Previous TopicNext TopicContents

You can apply a filter during the staretl process to pull over data based on pre-determined criteria. When you create a view, you can limit the projects you include in Star to a portfolio, an EPS, or another criteria; you can customize Star with only the projects that are important to you.

When creating the Star filter, you must be signed in as the pxrptuser you created with the P6 EPPM database.

Use this example to create a view for a portfolio called My Top 10 Projects and a filter called it_portfolio_view.

  1. Use the following to create the it_portfolio_view filter:

    create or replace view it_portfolio_view

    as

    select PROJECTOBJECTID objectid

    from projectportfolio pp, projectprojectportfolio ppp

    where pp.objectid = ppp.PROJECTPORTFOLIOOBJECTID

    and pp.name = 'My Top 10 Projects'

  2. Edit the staretl.properties file and add this entry with the name of the view you created.

    star.project.filter.ds1=it_portfolio_view

    where it_portfolio_view will be the name of your view.

  3. Run the following command:

    run staretl.bat

  4. After process completes, ensure you can connect to the view through the database link and return the list of object ids. For example:

    select * from it_portfolio_view@dslink01

    This will return the object id’s that will populate the etl_projectlist.

Related Topics

Post Installation Administrative Tasks

Securing the staretl.properties File

Clearing the Data for Star

Refreshing the Data for Star

Populate Data Sources with Filtered Project Data

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