Exporting OBIEE Reports to Excel

OBIEE Reports can be exported into Excel so they can be printed or saved for reference.

Select the report you would like to export.

• In this example we are using the Schedule Builder Data report in Mozilla Firefox.

Scroll to the bottom of the screen.

Click Export.

• In this example we are selecting Data, Tab delimited Format.

Click OK

Your report is now open in an Excel Spreadsheet.

Depending on the report you export you may want to remove the duplicate lines.

• Select all the rows and columns.
• Click Data (top of the screen)
• Click Remove Duplicates

Check the My data has headers box.
Click the Unselect All button.
Check the boxes on the following fields:

• Subject
• Catalog Nbr
• Class Sect
• Meeting Days
• Mtg Start Tm

Click OK.

This tells you how many duplicate values were removed and how many remain.
Click OK.

Now your report is much more manageable.

OBIEE Information

• OBIEE Overview
• Exporting OBIEE Reports

Schedule Builder Reports

• Approved Course Report. Lists courses that have the Approved checkbox checked in the Basic Data tab.
• Unapproved Course Report. Lists courses that DO NOT have the Approved checkbox checked in the Basic Data tab. These courses will not be Activated.
• Schedule Builder Data. Comprehensive list of classes an information. Melissa's favorite.
• New Condensed Schedule Builder. Pared down list of classes intended for schedulers.
• Simplified SBD. A single line report. Jill's favorite. Does not include Instructors nor Class Attributes. Use for bulk Instruction Mode submissions.
• Schedule Builder Notes/Requests. Used by Campus Schedulers to find new Notes/Requests from the Meeting tab.
• Schedule Builder Comments. Used by Department Schedulers to find comments from Campus Schedulers.
• Exam Notes. Used by Campus Schedulers to find new Final Exam Notes/Requests from the Exam tab.
• Combined Courses. Listing of classes that are in the Combined Section table. Shows Primary Instruction section and LMS flagging.
• Uncombined Courses. Courses that are not in the Combined Section Table but should be (XLST or CONJ Class Attribute)
• Final Exam. Lists Final Exam information once it has been added by the Campus Scheduler.