<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=982232216-01092006><FONT face=Arial
color=#0000ff size=2>We also use Business Objects here at $work. Could you
please send the scripts to me as well? Or even better, put them on the wiki.
:-)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=982232216-01092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=982232216-01092006><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=982232216-01092006><FONT face=Arial
color=#0000ff size=2>Drew</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Torsten
Brumm<BR><B>Sent:</B> Friday, September 01, 2006 12:03 PM<BR><B>To:</B>
Stephen Turner<BR><B>Cc:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] RT - Data
Warehouse?<BR></FONT><BR></DIV>
<DIV></DIV>Hi Stephen,<BR><BR>yes, we have. We put all the data from RT DB to
Business Objects and do the reporting there. If you like, i can sent you the
scrips for that<BR><BR>Torsten<BR><BR>
<DIV><SPAN class=gmail_quote>2006/9/1, Stephen Turner < <A
href="mailto:sturner@mit.edu">sturner@mit.edu</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hello,<BR><BR>Has
anyone moved data from an RT system to a data warehouse for <BR>reporting
purposes? If so, would you be willing to share your<BR>experiences? I'm
interested in the design of the warehouse data<BR>structures, particularly
how to accommodate custom fields.<BR><BR>Thanks,<BR>Steve<BR><BR>Stephen
Turner<BR>Senior Programmer/Analyst - Client Support Services<BR>MIT
Information Services and Technology
(IS&T)<BR><BR><BR>_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: <A
href="mailto:sales@bestpractical.com">sales@bestpractical.com</A><BR><BR><BR>Discover
RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>Buy a copy at
<A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>MFG<BR><BR>Torsten Brumm<BR><BR><A
href="http://www.torsten-brumm.de">http://www.torsten-brumm.de</A>
</BLOCKQUOTE></BODY></HTML>