nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Ability to Add Query Filter to Job Schedule in BICC from Rest API

user716429-Oracle

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

Find more posts tagged with

Submitted

Cross Pillar

ERP Analytics Content

Status: Submitted

Comments

Dave Kekish

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.