Creating a Filtered ODS

Previous TopicNext TopicContents

You can apply a filter during the odsetl process to pull over data matching a determined criteria. The P6 EPPM extended tables and P6 EPPM database calculate the data. When you create a view, you can limit the projects you include in ODS to a portfolio, an EPS, or another criteria; you can customize ODS with only the projects that are important to you.

When creating the ODS filter, you must use the PxRptUser.

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 odsetl.properties file in \res:
    1. Add this entry:

      ods.project.filter.ds1=

    2. Enter the name of the view you created. For example:

      ods.project.filter.ds1=it_portfolio_view

  3. Run the following command:

    run odsetl.bat

  4. After the 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@ods2pxrpt

    This will return the objectid’s that will populate the etl_projectlist.

Related Topics

Post Installation Administrative Tasks

Securing the odsetl.properties File

Clearing and Refreshing the Data

Scheduling the ODS Database Update

Manually Launching the ODS Database Update Process



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

Last Published Friday, January 31, 2014