Adcom, OLFS and adhoc info I gathered...

• Information
  • UCSF's excellent official OLFS site http://itssrv1.ucsf.edu/olfs/
  • UCSF's adhoc reporting site http://www.ucsf.edu/olfs/adhoc.html
  • UCSF weblinks course.
  • UCSF drawing depicting the various data access components.
  • Filemaker 4.1 with ODBC and a very nice overview of what ODBC is.
  • Nice pivot table tutorial
• Tools
  • UCSF's ledgerlink site http://itssrv1.ucsf.edu/its/links/
  • UCSF's tool of choice, Brio, for adhoc reporting.
  • UCSF's Connectivity to Oracle database client.
  • Filemaker 4.1 with ODBC and a very nice overview of what ODBC is.
  • Microsoft Excel 98 info.
• Solutions
  1. CVRI's Oracle/Excel Adhoc reporting (see below)
  2. Pharmacy's Weblinks/Excel import solution
  3. :-)

New ABOG presentation 3/22/99.

Process to get up and running on CVRI's Oracle/Excel Adhoc
reporting is as simple as