Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BICC - Set Extract Date for Individual PVO in a JOB
Hi All,
We have a job for data extracts which extracts data from Around 100 PVOs. In our initial extract some pvos were erroring out due to timeout issue. So we separately ran them in different jobs . Now our data is extracted but would like to move those PVOs back to the original job with the last extract date. how can we do that?
Regards,
Siddharth Dang
Answers
-
you can certainly update last extract date for selected PVO or whole offering (having many more PVO) in BIACM--> manage schedules
0 -
Hi @AnkitR Gupta ,
I could not find any option to set the last extract date for individual PVO in a job. I can either set the last extract date at the whole job level or set the initial extract date of a PVO. In the later case, it filters on the basis of the created date rather than the last update date. So there may be chances of a data loss.
Are you aware of any other method to set the last extract date?
Regards,
Siddharth Dang
0 -
Hi SiddharthDang-Oracle ,
Can you try the following and let me know if that helps
- Navigate to Advanced Extract Configuration option for an individual PVO.
- Setup the Initial Extract Date .. to the desired Last Extract date.
- Reset the individual PVO to Full Extact.
Thanks
Dimple N
0 -
or you can use update PVO with where clause to restrict data as well.
1
