Predefined OBIEE topic reports

Provides the total elapsed time in days that each Topic Action spent in a specific state. Computes the elapsed time using the Topic Action Modification Date. If this date is unavailable, computes the time using the Topic 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

Sample Report

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

Sample Report (partial)

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

Sample Report (partial)

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.

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.

• 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

Sample Report

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.

Sample Report

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

Sample Report

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

Sample Report