1. User Guide and Online Help
  2. Use Oracle Empirica Topics
  3. Work with topics
  4. Viewing topic reports
  5. Predefined Oracle Business Intelligence topic reports

Predefined Oracle Business Intelligence topic reports

Predefined Oracle Business Intelligence reports are available from a link on the Topic Management page if your database administrator and IT administrator installed and configured Oracle Business Intelligence and its components.

The following sections describe the predefined reports that are available.

Note:

Options in drop-down lists appear in case-sensitive alphabetical order.

Action State Timelines

Description Filters for Data Retrieval Columns

Provides the total elapsed time in days that each Action spent in a specific state. Computes the elapsed time using the Action Modification Date. If this date is unavailable, computes the time using the Action Creation Date.

Sorted in order by Topic ID by Action ID by Action Version ID. Action Version ID is not a visible field.
  • Project
  • Topic name
  • Action Name
  • Project
  • Topic ID
  • Topic Name
  • Action ID
  • Action Name
  • Action States

Action State Timelines Sample Report

Oracle Business Intelligence reports: Action State Timelines

Actions by Status

Description Filters for Data Retrieval Columns

Provides topic information based on action status.

Sorted in order by Action Status by Planned Completion Date by Action Name.
  • Action Status
  • Project
  • Topic Action Modified Date From/To

Note: To ensure that the query retrieves all data for a specific day, you should increase the date in the To field by 1 day. For example, to retrieve topics with Action Modified dates from 02/01/2012-02/04/2012, specify a From date of 02/01/2012 and a To date of 02/05/2012.

  • Action Status
  • Planned Completion Date
  • Action ID
  • Action Name
  • Action Description
  • Action State
  • Action Assigned To
  • Action Created By
  • Action Created Date
  • Actual Completion Date
  • Action Modified By
  • Action Modified Date
  • Topic ID
  • Topic Name
  • Topic Description
  • Topic State
  • Project
  • Topic Assigned To

Actions by Status Sample Report (partial)

Oracle Business Intelligence reports: Action by Status

Actions by Topic

Description Filters for Data Retrieval Columns

Provides topic information based on topic action.

Sorted in order by Project by Topic Name by Topic Modified Date by Action Name.
  • Project
  • Topic Name
  • Topic State
  • Action State
  • Project
  • Topic ID
  • Topic Name
  • Topic Description
  • Topic Created Date
  • Topic Modified Date
  • Topic State
  • Resolution Date
  • Search Keywords
  • Action Name
  • Action Description
  • Action State
  • Action Assigned To
  • Action Status
  • Planned Completion Date
  • Actual Completion Date

Actions by Topic Sample Report (partial)

Oracle Business Intelligence reports: Actions by Topic

Attachments in Topics

Description Filters for Data Retrieval Columns

Provides topic attachment information.

Sorted in order by column from left to right.
  • Project
  • Topic Name
  • Source
  • Topic Modified Date From/To

Note: If a topic has not yet been modified, the topic Creation Date is used in topic retrieval.

  • Project
  • Topic ID
  • Topic Name
  • Source
  • Topic Attachment Name
  • Topic Attachment Created By
  • Topic Attachment Created Date
  • Topic Attachment Modified By
  • Topic Attachment Modified Date

Attachments in Topics Sample Report

Oracle Business Intelligence reports: Attachments by Topics

Topic Counts by Work Team/User

Description Filters for Data Retrieval Columns

Provides the number of topics in each state assigned to each user on one or more work teams, and the total number of topics assigned to the work team.

There is one table for each work team.

Sorted in order by work team user.

Note: Topics that are visible to a work team but are not assigned to a member of the work team are not included in the Work Team Total.

  • Work Team Name
  • Topics (count)
  • Topic State (one column for each)

Note: If no topics are in a given state, the Topic State column does not appear.

Topic Counts by Work Team/User Sample Report

Oracle Business Intelligence reports: Topic Counts by Work Team/User

Topic State Timelines

Description Filters for Data Retrieval Columns

Provides the total elapsed time in days that each topic spent in a specific topic state.

Sorted in order by Topic Version ID. Topic Version ID is not a visible field.

Note: If the total elapsed time is less than 12 hours, the time period appears as 0 days.

  • Project
  • Topic Name
  • Project
  • Topic ID
  • Topic Name
  • Topic Description
  • Topic State

Topic State Timelines Sample Report

Oracle Business Intelligence reports: Topic State Timelines

Topics by State

Description Filters for Data Retrieval Columns

Provides topic information based on topic state.

Sorted in order by State by Project by Topic ID.
  • Topic State
  • Project
  • Topic Modified Date From/To

Note: To ensure that the query retrieves all data for a specific day, you should increase the date in the To field by 1 day. For example, to retrieve topics with Topic Modified dates from 02/01/2012-02/04/2012, specify a From date of 02/01/2012 and a To date of 02/05/2012.

Note: If a topic has not yet been modified, the topic Creation Date is used in topic retrieval.

  • Topic State
  • Project
  • Topic ID
  • Topic Name
  • Topic Description
  • Topic Assigned To
  • Topic Created By
  • Topic Created Date
  • Topic Modified By
  • Topic Modified Date
  • Resolution
  • Resolution Date

Topics by State Sample Report

Oracle Business Intelligence reports: Topics by State

Parent topic: Viewing topic reports