Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Ability to Add Query Filter to Job Schedule in BICC from Rest API
Organization Name
The Cleveland Clinic Foundation
Description
We are setting the data filter programmatically for PVO using the PUT method of the following Rest API:
https://<>.oraclecloud.com/biacm/rest/meta/datastores/ FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO
The Rest API is NOT working as expected as it is configuring the Data Filter at the Base PVO offering and not at the Job Schedule that is already configured.
Use Case and Business Need
We need to extract full PVO extracts periodically, but due to huge data volumes on some of the PVO's, we are trying to limit the extracts to a few months to prevent timeouts on the process to extract, transfer and upload the data on the target systems.
More details
We need to change the data filter at the PVO Job Schedule level.
Original Idea Number: 09d1e3e760
Comments
-
The inability to alter an existing job with regards to a customized pvo seems to be a severe limitation on the usefulness of this api functionality.
If I want to customize a base pvo, I put it in a job. If i want to schedule an extract of a pvo, it goes into a job. however, if I want to use the rest api to alter the filter of a pvo, that applied to the base pvo and will never apply to the pvo I have in the job. Why would I want that?
Any API that can be used to "customize" the base pvo objects, should also be able to apply customizations to the pvo that is associated with a job. this would include column selection/deselection, filtering, etc.
0
