Oracle Transactional Business Intelligence Idea Lab

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

Ability to Add and Save Notes to an OTBI Report

1
Views
0
Comments
Erika Szewczyk_UCSD
Erika Szewczyk_UCSD Rank 1 - Community Starter

Description

Ability to add and save notes to an OTBI report, similar to a write-back feature, where you do not have to configure/update a DFF through the UI and are not restricted to the 150 character limitation that DFFs have.

Use Case and Business Need

We have several reports that get generated and sent to external sponsors, clients, partners, etc. where we need to include additional notes or information that are not and do not need to be captured within the UI. These notes are meant to be incrementally added and not necessarily overridden as new information/updates come to light.

Example of Desired Functionality:

  1. A report is generated by an end user that contains a free form text field that can be populated by that end user and then saves the report. Once the report is saved with the additional note, the note is sent to the desired audience.
  2. A week later, the end user runs the report again where the note added previously is still visible. The user adds a new note and saves to the report where now both notes are displayed, and the updated report sent to the desired audience.
  3. An additional week later, the end user runs the same report where both notes added previously are still visible. The user selects the second note and edits the information and saves, and the report displays both notes with the second one reflecting the changes just made. The report is now ready to be sent to the desired audience.
  4. An additional week later, the end user runs the same report where both previous notes are displayed. The user “inactivates” or “end dates” the first not added, and adds a new third note, and the report displays all three notes. The report is now ready to be sent to the desired audience, but when it is sent, the report only displays the second and third note added, and NOT the first date because it has been “inactivated” or “end dated”.

Original Idea Number: 4934d779b1

1
1 votes

Submitted · Last Updated