• Calendar
• A-Z Index

Find it

• About ITS
• Policies
• Feedback
• Search ITS
• ITS A-Z Index
• System Status

Data Warehouse Portal 9 & BrioQuery 9 upgrade

Timeline			Tools & help
	February 16, 2009 BrioQuery Version 6 is no longer available Completed Upgrades: Brio Users Group (BUG) Report Library DataWarehouse Reporting Portal 9 HR-Self Service Reports			Training material Fast answers to questions User Impact

 

Announcement: February 16, 2009

• On February 15th, BrioQuery Version 6 was retired. All queries will now open in BrioQuery Version 9.
• Message from Gwen Sykes - February 4, 2009

Announcement: December 10, 2008

1. Several Account Holder by PTAEO by Person reports did not automatically generate on Monday, December 8, due to a failure of Brio 9 to handle reports where there had been no charges to a PTAEO during the November period.  As a result, the intended recipients received emails with no report. These reports were regenerated manually and distributed on Tuesday, December 9. If you did not received a report or if you received an email with no report output, please contact dw.usersupport@yale.edu.

2. If you are an author of reports in the DataWarehouse Reporting Portal who sends report output via email, you should be aware of the following:

• Since the upgrade, we have seen a small percentage of report outputs that have increased in size beyond what is allowable through the University’s email servers.  On December 9th, attachment size on the University’s email servers was increased from 10 mb to 20 mb.
  

• Based on the November month-end close, it is expected that less than 1% of report outputs contained in Portal (104 of the 12,000) will be undeliverable via email without additional manipulation from the report authors.
  

• If you have output files that you know exceed this 20 mb limit, please download the reports from the Portal directly and contact dw.usersupport@yale.edu for assistance.
  

• Many report outputs in Version 9 are larger than they were in Version 6.
  

• Email recipients of all report outputs generated from the Portal should move the email with its attachment from the inbox to a locally created folder.

Training material

1. BrioQuery Advanced Tips
2. Best Practices and Recommendations
3. DataWarehouse Quick Reference Guide
4. DataWarehouse Reporting Portal 9 training presentation
5. BrioQuery 9 User's Guide

Quick tips: What do I do?

1. List of BUG Library queries to re-download
2. Check out the FAQ for unexpected results and document links
3. Contact the team for answers to your questions
   

BUGS that will need to be re-downloaded: BUG101a Labor Distribution By Employee BUG102a Labor Suspense Report BUG105a Student Employment Split BUG109a C&T Salary Projection BUG110a ITS FTE Billing Counts BUG209a Account Holder Listing BUG213a Account Holder Report for Cost Sharing BUG309a Assets & Liabilities BUG310a Commitments BUG402a Compare Period Actuals BUG402b Compare Yearly Actuals

Data Warehouse Portal & BrioQuery upgrade team contacts

Project team email:	Hyperion9Upgrade_ProjectTeam@mailman.yale.edu
Vijay Menta	Technical Lead	436-3958	vijay.menta@yale.edu
Karissa Williams	Project Manager	436-8315	karissa.williams@yale.edu
Julianne Amarante	Business Systems Analyst	436-8992	julianne.amarante@yale.edu
Michael Satterwhite	Business Systems Analyst	432-4660	michael.satterwhite@yale.edu
Stephanie Lango	Deployment Specialist	436-8421	stephanie.lango@yale.edu

Additional resources

Financial Support Services	GA.Usersupport@yale.edu
ITS Help Desk	helpdesk@yale.edu	432-9000	785.3200