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.
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'
star.project.filter.ds1=it_portfolio_view
where it_portfolio_view will be the name of your view.
run staretl.bat
select * from it_portfolio_view@dslink01
This will return the object id’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