Oracle Transactional Business Intelligence Idea Lab

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

Ability to get the latest BICC PVO Lineage with a Soap or Rest API by Release

1
Views
0
Comments
user716429-Oracle
user716429-Oracle Rank 3 - Community Apprentice

Organization Name

The Cleveland Clinic Foundation

Description

For maintainability purposes, we need to get the latest BICC PVO Lineage frequently.
It is difficult to find information related to a BICC PVO in the current excel spreadsheets provide with the lineage as of 21A release, if there is a repository with the latest information of all the PVO’s that can be accessed via API it will be easier to maintain an to identified deprecated attributes.

Use Case and Business Need

PVO changes such as adding columns to an extract or removing deprecated columns from an extract is proving to be challenging as not always these changes are documented in the corresponding lineage document.
We need to compare the changes of columns on the Lineage for all approximately 125 PVOs being used to extract data from ERP Cloud when there are changes.

More details

The PVOs are segregated in different spreadsheets and sometimes is not clear which spreadsheet will contain the lineage for a specific PVO, especially when the PVOs are across pillars.

Original Idea Number: 9e283806c7

1
1 votes

Submitted · Last Updated