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

103
Views
2
Comments

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

2
2 votes

Submitted · Last Updated

Comments

  • John Dzurik
    John Dzurik Rank 1 - Community Starter

    This is a need of our group too.

  • David Langford
    David Langford Rank 1 - Community Starter

    Lineage document is out-of-date.
    Metadata information is incorrect.
    Names are different in different areas making it difficult to line up date from OTBI, extracts, queries, API's, etc...