Applications User Experience

Fusion Reporting
User Interface Design Document

Version 0.1
July 7, 2008

Copyright © 2008 Oracle Corp. All Rights Reserved. Confidential.

author:

Heather Cottingham

contributors:

John Cartan, John Bagby, Claudia Castro, Florian Schouten

reviewers:

approvers:

 


Revision history

version

date

author

notes

0.1

March 4, 2008

Heather Cottingham

Created

 

 

 

 


Contents

About this document
Executive summary
Assumptions
Definitions
Requirements
     - Appearance
     - Navigation
     - Viewing
     - Hover
     - Folders
     - Contents


About this document

This document specifies default state of the Fusion Reporting and Analytics pane. It is unknown how much functionality may need to be built. See the list below for details. Most content will be provided as part of other projects, but get surfaced here.


Executive Summary
The Reporting and Analytics pane will be a default pane in the regional area. It will contain a list of all reports in context from BIP and OBIEE that are available to the user.

Assumptions

Definitions

Requirements

In the default out-of-the-box state, the different reporting content will be offered for different roles.
Reporting and Analytics Pane - located in the regional area
Reporting and Analytics Dashboard Region - can be addded from the catalog
Reporting Center - contains links to all OBIEE and BIP reports (may contain links to Hyperion reports)

Appearance

The appearance of the Reports and Analytics pane will follow Fusion standards.

Navigation
  1. Ability to launch reporting engines from Reports and Analytics pane.
  2. Ability to launch Report Center and Hyperion from Navigation menu
Viewing

Users can view reports in the following ways:

  1. Clicking on the report name in the Reports and Analytics pane. The report will open in another window. The local area will not change.
  2. Clicking on the view icon in the hover bubble.
  3. Selecting a report name in a drop down button or link in the local area.
Folders
  1. Available reports are contextual based on the user's security, role and task.
  2. Not all reports will be available in the reporting and analytics pane. All reports should be available in the Report Center.
  3. Folder can have subfolders.
  4. If no reports are displayed for a folder, the folder should be hidden.
  5. Standard folder should exist in all applications:
    1. My Reports - Reports the user has created
    2. My Favorites - Reports the user has marked as Favorite
    3. Recent Reports - Reports that the user has recently run
    4. Open Issue: Implementation wise, do these corresponding with OBIEE folders?
  6. Folder name truncation should be automatic based on the width of the pane. If truncation is not available, short and long report names will be needed.
  7. Icons should not be used in the tree to increase space for report names.
  8. Open Issue: What is the mapping of Reporting Pane content and OBIEE foldering structure for the current user? Is this going to be handled by selecting folders for a particular context or by a tagging mechanism? What is possible technically?
Hover

Hovering over a report name in the reporting and analytics pane will display a pop-up window with additional information and actions.

  1. Contextual actions in the hover bubble are based on permissions and availability. These include:
    1. View / Open - Clicking on the report name in the page will immediately display the report in a new window.
    2. Create - will take the user to the create report screen. In certain cases, it will take the user to a set of pages to create complex reports. If the report is an OBIEE report, the user will be taken to the OBIEE create report page. If the report is an Essbase report, the user will be taken to the Hyperion Essbase create report page.
    3. Duplicate - will duplicate the report and open the properties dialog and require the user to give the report a new name
    4. Edit - will open the report properties dialog and allow the user to edit the parameters shown or the layout
    5. Rename - will open the report properties dialog and allow the user to save the report with a new name.
    6. Schedule - will take the user to the report properties dialog with the schedule section opened.
    7. History- will open a dialog showing the history of all reports run, if available. OBIEE reports will generally not have any history saved.
    8. Favorites - will add this report to the user's favorites.
  2. Information presented in the hover bubble will be pulled from existing metadata. Some examples may include:
    1. Full report name
    2. Create by user
    3. Create date
    4. Last run date
    5. Type
Note: The image below is for visualization purposes only and is not final.


Content
Home
  1. Reporting and Analytics dashboard region (or portlet ?) -- not accordion pane -- is needed
  2. Should provide access to all OBIEE content that the user has access to. This may translate into the top level folders in OBIEE.
Workarea and Transaction Dashboards
  1. Need to provide access to OBIEE content relevant to the current context
  2. Dev team needs to have the ability to “tag” or register content that is relevant to a particular context (workarea or dashboard)
  3. Customers needs to be able to customize what is shipped out of the box, including creating new reports and registering them so they will appear in the appropriate Reporting & Analytics pane in workareas and dashboards.
Report Formats

Reports can be displayed in any of the following formats (.doc, .xls, .pdf, .rtf, .ppt, .html, Flash), although we expect most reports to be PDFs. Teams producing documents in these formats are responsible for the accessibility of their reports. For example, teams producing PDFs will need to follow Adobe's instructions on how to create accessible PDFs from their website at http://www.adobe.com/accessibility/

Frame Work Functionality Needed
  1. Add Report to Pane - A flag that will add the report to the reports and analytics page. This flag will need to be available starting at report creation time, although users will want to add reports at a later date as well.
  2. Max Number of Reports shown - The maximum number of reports shown in a single folder of the pane. This limitation will prevent the number of reports listed from getting too long.
Reporting Flow Chart

Open Issues
  • Is there any possibility that the reporting pane will be empty for a particular user? If so, should we request that it be hidden?
  • Who owns the Unified Report Catalog?
  • Who owns Report Center? When will there be a detailed design for it?
  • Will XML Publisher work for UX's needs?
  • Will there be Discover like reporting to support ad hoc queries? (SCM)

Related Links