Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICC : Reset Last Extract Date at PVO Level

106
Views
0
Comments

Organization Name

World Wide Technology

Description

Summary:
To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings level
Description:
Currently there are two ways change the Last Extract Date filter within BICCC outside of the built in incremental Logic BICCC has.

1. Reset to Full Extract : You can do this at the PVO level. Or you can do multiple PVOs within an Offering. These are both great features which we use often.

2. Reset the Last Extract Date : This is a feature on the main page which is only available across the BICCC (encompassing all offerings). Although this is a good feature, the fact that its not available at individual PVOs level as well as Offerings level is an impediment to use this feature well especially in growing DB. We would greatly appreciate if this can be added to BICCC.

Use Case and Business Need

When we want to face issues and want to reprocess a few days worth of records on certain Large PVOs like XLA related ones, doing Full load is extremely time consuming and wasteful of resources. On the other hand, resetting all PVOs back to the same number of days needed for the XLA PVO also seems like resource wastage. 

Ability to reset Last Extract Date especially at PVO level would really mitigate the said issue.

Original Idea Number: 9d2c921b6b

1
1 votes

Submitted · Last Updated