Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

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

Submitted
569
Views
1
Comments
user716429-Oracle
user716429-Oracle Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

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

Tagged:
3
Up
3 votes

Submitted · Last Updated

Comments

  • Dave Kekish
    Dave Kekish Rank 5 - Community Champion

    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.