<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18203" name=GENERATOR>
<STYLE>@font-face {
        font-family: Cambria Math;
}
@font-face {
        font-family: Calibri;
}
@font-face {
        font-family: Tahoma;
}
@font-face {
        font-family: Consolas;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
        COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
        COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
        COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
        COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
PRE {
        FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"; mso-style-priority: 99; mso-style-link: "HTML Preformatted Char"
}
SPAN.HTMLPreformattedChar {
        FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "HTML Preformatted"; mso-style-name: "HTML Preformatted Char"
}
SPAN.EmailStyle19 {
        COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
        FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
        page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2>I think we have multiple solutions to the same problem. I
have been developing mondrian/bin/loadFoodMart.sh , which has a target for each
major database, and using it each time I need to install a mondrian dev
environment on a test machine.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2>Problem with Sherman's solution is that this requires ant
to run in a runtime environment.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2>We can each continue to do things our own way, but what do
we recommend to folks who are installing mondrian for the first time? I think
the instructions in install.html are adequate.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=197582719-18032009><FONT face="Lucida Sans"
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 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> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Sherman
Wood<BR><B>Sent:</B> Wednesday, March 18, 2009 10:10 AM<BR><B>To:</B>
'Mondrian developer mailing list'; jhyde@pentaho.com<BR><B>Subject:</B> RE:
[Mondrian] SteelWheels data set<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">There
is a load-foodmart target in the build script now checked in. It will be there
in the next release.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Sherman<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org] <B>On
Behalf Of </B>Aaron Phillips<BR><B>Sent:</B> Thursday, March 19, 2009 12:03
AM<BR><B>To:</B> jhyde@pentaho.com; Mondrian developer mailing
list<BR><B>Subject:</B> Re: [Mondrian] SteelWheels data
set<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I don't know if anyone would find this (attached) script
useful; I've loaded FoodMart enough times to want to script the process.
I used this (bash) script just a month or so ago, so it is ivy-aware.
The idea is you can run this script from a clean Mondrian distribution and
load foodmart in one step. Perhaps it could be generalized to load other
schemas amoung other things. <BR>I have the script living in
<mondrian-install>/bin, e.g. /opt/mondrian3.0/bin in my
environment.<BR>-Aaron<BR><BR>On Tue, 2009-03-17 at 16:54 -0700, Julian Hyde
wrote: <o:p></o:p></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; COLOR: navy">I have added
Mondrian's SteelWheels data set and a test case that uses it. SteelWheels is a
smaller data set than FoodMart, and will be familiar to many of you as the
data set installed when Mondrian is part of the Pentaho suite.</SPAN>
<o:p></o:p></P>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; COLOR: navy">We've always
asked for bug testcases to be in terms of the FoodMart data set. >From now
on, we will be accepting test cases on SteelWheels too.</SPAN>
<o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; COLOR: navy">To write a
test case, add a method to SteelWheelsTestCase.java, and copy-paste one of
the existing tests.</SPAN> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; COLOR: navy">For details on
how to install the data set, see </SPAN><SPAN style="COLOR: navy"><A
href="http://p4webhost.eigenbase.org:8080/open/mondrian/doc/install.html">http://p4webhost.eigenbase.org:8080/open/mondrian/doc/install.html</A></SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: navy">. Currently there is a only a loader
for MySQL. But I know you're an ingenious bunch, who will figure out how to
load it into other databases...</SPAN> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal> <o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; COLOR: navy">Julian</SPAN>
<o:p></o:p></P></BLOCKQUOTE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt"><PRE><o:p> </o:p></PRE><PRE>_______________________________________________<o:p></o:p></PRE><PRE>Mondrian mailing list<o:p></o:p></PRE><PRE><A href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A><o:p></o:p></PRE><PRE><A href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</A><o:p></o:p></PRE></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>