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

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)

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)

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

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

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

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