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. |
|
|
Action State Timelines Sample Report
![Oracle Business Intelligence reports: Action State Timelines Oracle Business Intelligence reports: Action State Timelines](img/action_state_timelines2.gif)
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. |
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. |
|
Actions by Status Sample Report (partial)
![Oracle Business Intelligence reports: Action by Status Oracle Business Intelligence reports: Action by Status](img/actions_by_status2.gif)
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. |
|
|
Actions by Topic Sample Report (partial)
![Oracle Business Intelligence reports: Actions by Topic Oracle Business Intelligence reports: Actions by Topic](img/actions_by_topic2.gif)
Attachments in Topics
Description | Filters for Data Retrieval | Columns |
---|---|---|
Provides topic attachment information. Sorted in order by column from left to right. |
Note: If a topic has not yet been modified, the topic Creation Date is used in topic retrieval. |
|
Attachments in Topics Sample Report
![Oracle Business Intelligence reports: Attachments by Topics Oracle Business Intelligence reports: Attachments by Topics](img/attachments_in_topics.gif)
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. |
|
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 Oracle Business Intelligence reports: Topic Counts by Work Team/User](img/topic_counts_by_work_team_user.gif)
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. |
|
|
Topic State Timelines Sample Report
![Oracle Business Intelligence reports: Topic State Timelines Oracle Business Intelligence reports: Topic State Timelines](img/topic_state_timelines2.gif)
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. |
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. |
|
Topics by State Sample Report
![Oracle Business Intelligence reports: Topics by State Oracle Business Intelligence reports: Topics by State](img/topics_by_state.gif)
Parent topic: Viewing topic reports