Business Systems Data Warehouse
Last Updated: October 27, 2006

The Business Systems Data Warehouse has been in production since October, 2005. Below are the reports available through this reporting system.

Budget Center Daily Reports
BI Invoice Aging Detail
Billing Invoice Errors
Billing Invoice Payments for Current, Prior Month and All months
BSR Daily Summary
Journal Budget Check Errors
Journal Header/Line Errors
PO Budget Check Errors
PO Requisitions Unapproved
Statement of Changes with Account Detail for CU, CUF, CURF
Trial Balance by Project for CU, CUF, CURF
Voucher Errors
Vouchers Unapproved

PI Reports
PI Project Grant Budget vs Actual

Budget Center Monthly Reports – by month
BSR Detail for Expenditures
BSR Detail for Grants and Contracts
BSR Detail for Revenue
BSR Summary for Expenditures
BSR Summary for Grants and Contracts
BSR Summary for Revenue

Finance User Run Reports
Billing Invoice Payments
Budget Amendment Transactions Report
BSR Detail For Expenditures
BSR Detail For Grants and Contracts
BSR Detail For Revenue
Statement of Changes - Year to Year Comparison with Account Detail
Statement of Changes in Fund Balances
Statement of Changes with Account Detail
BSR Summary For Expenditures
BSR Summary For Revenue

HR User Run Reports
Job History

Frequently Asked Questions (FAQs)
1) What information is stored on the Business Systems Data Warehouse?
Data is copied nightly from the Peoplesoft Financial and Human Resources databases. Financials and HR data is available to Users. For HR reports, Users only have access to data they have security to see in Peoplesoft.

2) How do I get to the Business Systems Data Warehouse and login?
Using Internet Explorer, go to https://busdwh.clemson.edu
Enter your Novell userid and password and click LOGIN on the login screen that is displayed.

3) When I try to set my initial folder to my budget center, the OK button is grayed out.
After selecting your budget center and daily reports, be sure to click once on the words Daily Reports so it is shaded. Now the OK should be ungrayed and click it to set your beginning folder.

4) I select my preferences and click OK, but when I log on I am still on the Business Objects XI home page. My preferences didn't get saved.
While on the General Preferences screen, after selecting the initial folder to be displayed when logging into the Data Warehouse and clicking on OK, the general preferences screen will be redisplayed. Be sure to scroll to the bottom of the page and click Apply. Apply will save your general preferences and leave the screen displayed, if you click OK it will return you to the reports menu.

5) After selecting View Latest Instance for a report I get "page requested not found". Why doesn't it show my report? (I selected ActiveX as my Crystal Reports preference)
This is an issue with IE, ActiveX and Windows 2000. Select preferences and then select the Crystal Reports preferences tab. Click the button beside DHTML viewer (instead of ActiveX). Then beside "DHTML printing uses" click the button beside "Acrobat Reader printing control". Then scroll to the bottom of the screen and click OK. The report menu should be displayed, try the report again.
When you print a report, a page will be displayed asking you to select the pages to be printed, after selecting all or the page range, click ok. The pages to be printed will be displayed in Acrobat Reader and then you can click the print bottom. You may get a pop up asking to say it is ok to use Acobat Reader, just say okay to the pop up.
If you are having trouble printing after selecting Acrobat Reader printing control, click here.

6) The first page of my report is showing, but the browser bar at the bottom is not finished.
The browse bar at the bottom of the page just indicates that Business Objects is still working. If the first page is shown your report is ready for you to view even though the top of the page just shows pages 1/1+. Just remember to tab to the next page using the navigation (arrows) buttons at the top. Once the next page button is pressed it will show how many pages are in the report.

7) I would like to see my report in the full browser window so I can see the whole report.
Under the preferences - General Preferences, view my reports click on the button beside "View my documents in a single full screen browser window, one document at a time" and scroll to the bottom and click OK. Now your reports will be displayed in your whole window. Just click the X to close the report and redisplay the report listing.

8) The headings are missing from my reports.
Some of the reports have drill down capability. If you double click (instead of single click) on the drill down data shown on the left side of the report, Business Objects will display that section of the report in a new tab. Now you will have a preview tab and a detail tab. Be sure to look at the report in the preview tab, this is where the headings show. Also, close the detail tab when printing to get the headings.

9) I still need more help......
Remember there is training and documentation at http://www.clemson.edu/humanres/Training_Develop/classes.htm under Business Systems Data Warehouse Reporting. If you still have questions or problems please email DWHHELP-L@clemson.edu.