Ability to audit which fields are being used in OTBI reports — Oracle Analytics

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 audit which fields are being used in OTBI reports

Submitted
61
Views
6
Comments
Colin Smith
Colin Smith Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

Nationwide Building Society

Description

Either a build audit function displaying which fields are being used in which OTBI reports, or an export displaying this information.

Use Case and Business Need

Would give the ability to check which reports are impacted by any changes to OTBI fields due to patches & releases, making it easier to prioritise testing of reports to make sure information is correct.

Original Idea Number: 87d6d5d436

Tagged:
3
Up
3 votes

Submitted · Last Updated

Comments

  • Hamish Vickers
    Hamish Vickers Rank 2 - Community Beginner

    This would be a great feature.
    Many customers require heavy auditing features - and are often left frustrated by the lack of auditing power that Oracle offers.

  • Richard Kemp-Eyre
    Richard Kemp-Eyre Rank 5 - Community Champion

    This would allow us to rapidly identify fields which may be impacted by a Quarterly Release change.
    It would also allow us to identify fields being used which need modification e.g. through the use of formulas, or removing and replacing with a different field. Our dashboards may be built up with hundreds of individual prompts, analytics and filters and trying to identify which ones use a specific field can be very time consuming.

  • Lisha Thomas
    Lisha Thomas Rank 1 - Community Starter

    Able to easily identify fields impacted mainly during releases.

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    This would be very helpful to especially be ready for patches

  • user631051
    user631051 Rank 3 - Community Apprentice

    Our company is heavy on auditing, this would help us greatly in that regards and assist with preparing for patch/maintenance.

  • Liz Pellegrin
    Liz Pellegrin Rank 1 - Community Starter

    This would be a great tool to also use in cases where we are changing DFFs or other means of recording data, so that we can identify which custom BI reports would be impacted by being able to write a custom BI report that in turn searches through data set SQL for a given search string (ie table/view or field name).