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.
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'
ods.project.filter.ds1=
ods.project.filter.ds1=it_portfolio_view
run odsetl.bat
select * from it_portfolio_view@ods2pxrpt
This will return the objectid’s that will populate the etl_projectlist.
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014