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

Colin Smith

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

Find more posts tagged with

Submitted

Analysis

OTBI

Status: Submitted

Comments

Hamish Vickers

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

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

Able to easily identify fields impacted mainly during releases.

Rich Merkel

This would be very helpful to especially be ready for patches

user631051

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

Liz Pellegrin

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).