<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =
"urn:schemas-microsoft-com:office:office"><HEAD><TITLE>Nachricht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18099" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=862030920-07092008><FONT face=Verdana
color=#000080 size=2>Found this email in my inbox - 8 months ago! Better
late than never. Andrae's patch - which converts TIME and TIMESTAMP measures to
strings internally - is a bit of a hack, and I won't be including it in the
mondrian main line, but some of you might find it a useful. I have logged bug
2099134 <A
href="http://sourceforge.net/tracker/index.php?func=detail&aid=2099134&group_id=35302&atid=414613">http://sourceforge.net/tracker/index.php?func=detail&aid=2099134&group_id=35302&atid=414613</A> to
fix the problem properly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=862030920-07092008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=862030920-07092008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
mondrian-devel-bounces@lists.sourceforge.net
[mailto:mondrian-devel-bounces@lists.sourceforge.net] <B>On Behalf Of
</B>Ruediger.Andrae@first-financial.biz<BR><B>Sent:</B> Thursday, November 08,
2007 5:59 AM<BR><B>To:</B>
mondrian-devel@lists.sourceforge.net<BR><B>Subject:</B> [Mondrian-devel] Patch
for mondrian<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial size=2>I have a Patch for
this problem:</FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial size=2><IMG
src="Outlook.bmp"></FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial size=2>
<DIV><SPAN class=600564913-08112007><FONT face=Arial size=2>TIME_JZ_VON ZP and
TIME_ZP_BIS_ZP are java.sql.Timestamps. Method processData crached for these
type (near line 390).</FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007></SPAN> </DIV>
<DIV><SPAN class=600564913-08112007></SPAN> </DIV></FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600564913-08112007><FONT face=Arial size=2>Cube Definition
is:</FONT></SPAN></DIV>
<DIV><SPAN class=600564913-08112007><FONT size=2><FONT
face=Arial></FONT> </DIV>
<DIV align=left><FONT face=Arial><!-- Cube zeigt CPU-Verbrauch und Laufzeiten
pro Job bis auf Tagesebene, die am Tag nur 1x laufen --></FONT></DIV>
<DIV align=left><FONT face=Arial><Cube name="JZ_Anteil2"></FONT></DIV>
<DIV align=left><FONT face=Arial><View alias="V_ADM_JZJOB2"></FONT></DIV>
<DIV align=left><FONT face=Arial><SQL dialect="generic"></FONT></DIV>
<DIV align=left><FONT face=Arial><![CDATA[SELECT JZJOBX.JOB_NAME,
JZJOBX.JOBZEIT_DAT,</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.JOBZEIT_VON_ZP,
JZJOBX.JOBZEIT_BIS_ZP,</FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG>TIME(JOBZEIT_VON_ZP) AS TIME_JZ_VON_ZP,
</STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG>TIME(JOBZEIT_BIS_ZP) AS
TIME_JZ_BIS_ZP,</STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.LAUF_DAUER_MS AS LAUF_DAUER_MS,
</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.CPU_DAUER_MS AS
CPU_DAUER_MS,</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.ANZ_STEPS,
JZJOBX.SUM_EX_CP,</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.COND_CODE, 1 AS ANZ_LAEUFE,</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.DIM_JAHR, JZJOBX.DIM_MONAT,</FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOBX.DIM_TAG</FONT></DIV>
<DIV align=left><FONT face=Arial>FROM ADM_JZJOB AS JZJOBX</FONT></DIV>
<DIV align=left><FONT face=Arial>JOIN ( SELECT JZJOB.JOB_NAME, </FONT></DIV>
<DIV align=left><FONT face=Arial>JZJOB.DIM_JAHR, JZJOB.DIM_MONAT,
JZJOB.DIM_TAG,</FONT></DIV>
<DIV align=left><FONT face=Arial>COUNT(*) AS ANZAHL</FONT></DIV>
<DIV align=left><FONT face=Arial>FROM ADM_JZJOB AS JZJOB</FONT></DIV>
<DIV align=left><FONT face=Arial>JOIN VAJOB_OLAP AS JOB</FONT></DIV>
<DIV align=left><FONT face=Arial>ON JZJOB.JOB_NAME = JOB.JOB_NAME</FONT></DIV>
<DIV align=left><FONT face=Arial>AND JOB.PRODSTATISTIK_KZ = 'J'</FONT></DIV>
<DIV align=left><FONT face=Arial>GROUP BY JZJOB.JOB_NAME, JZJOB.DIM_JAHR,
JZJOB.DIM_MONAT, JZJOB.DIM_TAG</FONT></DIV>
<DIV align=left><FONT face=Arial>) AS VJZ_EINMALJOBS</FONT></DIV>
<DIV align=left><FONT face=Arial>ON VJZ_EINMALJOBS.JOB_NAME =
JZJOBX.JOB_NAME</FONT></DIV>
<DIV align=left><FONT face=Arial>AND VJZ_EINMALJOBS.DIM_JAHR =
JZJOBX.DIM_JAHR</FONT></DIV>
<DIV align=left><FONT face=Arial>AND VJZ_EINMALJOBS.DIM_MONAT =
JZJOBX.DIM_MONAT</FONT></DIV>
<DIV align=left><FONT face=Arial>AND VJZ_EINMALJOBS.DIM_TAG =
JZJOBX.DIM_TAG</FONT></DIV>
<DIV align=left><FONT face=Arial>WHERE
VJZ_EINMALJOBS.ANZAHL=1]]></FONT></DIV>
<DIV align=left><FONT face=Arial></SQL></FONT></DIV>
<DIV align=left><FONT face=Arial></View></FONT></DIV>
<DIV align=left><FONT face=Arial><Dimension name="Job"></FONT></DIV>
<DIV align=left><FONT face=Arial><Hierarchy hasAll="true" allMemberName="Alle
Jobs" ></FONT></DIV>
<DIV align=left><FONT face=Arial><Level name="Job" column="JOB_NAME"
uniqueMembers="true"/></FONT></DIV>
<DIV align=left><FONT face=Arial></Hierarchy></FONT></DIV>
<DIV align=left><FONT face=Arial></Dimension></FONT></DIV>
<DIV align=left><FONT face=Arial><Dimension name="Zeit"></FONT></DIV>
<DIV align=left><FONT face=Arial><Hierarchy hasAll="true"
allMemberName="Gesamt" ></FONT></DIV>
<DIV align=left><FONT face=Arial><Level name="Jahr" column="DIM_JAHR"
uniqueMembers="true"/></FONT></DIV>
<DIV align=left><FONT face=Arial><Level name="Monat" column="DIM_MONAT"
uniqueMembers="true"/></FONT></DIV>
<DIV align=left><FONT face=Arial><Level name="Tag" column="DIM_TAG"
uniqueMembers="true"/></FONT></DIV>
<DIV align=left><FONT face=Arial></Hierarchy></FONT></DIV>
<DIV align=left><FONT face=Arial></Dimension></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="CPU Dauer"
column="CPU_DAUER_MS" caption="CPU-Verbrauch" aggregator="sum"
formatter="biz.ff.olap.DauerCellFormatter" /></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="LAUF Dauer"
column="LAUF_DAUER_MS" caption="Laufzeit" aggregator="sum"
formatter="biz.ff.olap.DauerCellFormatter" /></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="Min Dauer"
column="LAUF_DAUER_MS" caption="Min Dauer" aggregator="min"
formatter="biz.ff.olap.DauerCellFormatter" /></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="Mittlere Dauer"
column="LAUF_DAUER_MS" caption="Mittlere Dauer" aggregator="avg"
formatter="biz.ff.olap.DauerCellFormatter" /></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="Max Dauer"
column="LAUF_DAUER_MS" caption="Max Dauer" aggregator="max"
formatter="biz.ff.olap.DauerCellFormatter" /></FONT></DIV>
<DIV align=left><FONT face=Arial><Measure name="Anzahl" column="ANZ_LAEUFE"
caption="Anzahl Läufe" aggregator="sum" formatString="#,##0"/></FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG><Measure name="Min Startzeit"
column="TIME_JZ_VON_ZP" aggregator="min"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/></STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG><Measure name="Max Startzeit"
column="TIME_JZ_VON_ZP" aggregator="max"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/></STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG><Measure name="Min Endezeit"
column="TIME_JZ_BIS_ZP" aggregator="min"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/></STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial><STRONG><Measure name="Max Endezeit"
column="TIME_JZ_BIS_ZP" aggregator="max"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/></STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial></Cube></FONT></DIV>
<DIV></FONT></SPAN> </DIV><PRE></PRE><FONT face=Tahoma size=2><FONT color=#0000ff>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><I
style="mso-bidi-font-style: normal"><SPAN
style="FONT-SIZE: 9pt; mso-bidi-font-family: Arial"><FONT color=#000000><FONT
face=Arial>Aareal First Financial Solutions AG, Sitz der Gesellschaft: Wiesbaden
<BR>Handelsregister: Amtsgericht Wiesbaden HRB 12775
<BR>Aufsichtsratsvorsitzender: Thomas Ortmanns <BR>Vorstand: Georg Diehl
<BR><BR>Diese E-Mail inklusive aller Anlagen ist ausschließlich für den
Adressaten bestimmt und enthält möglicherweise vertrauliche Informationen. Falls
der Empfänger dieser Nachricht nicht der beabsichtigte Adressat oder ein für den
Mail-Zugang zuständiger Mitarbeiter oder Vertreter ist, werden Sie hiermit
darauf aufmerksam gemacht, dass jede Weitergabe, Verteilung, Vervielfältigung
oder sonstige Nutzung dieser Nachricht oder ihrer Anlagen verboten ist. Wenn Sie
diese Nachricht aus Versehen erhalten haben, informieren Sie bitte den Absender
per E-Mail und löschen Sie diese E-Mail aus Ihrem Computer.
<o:p></o:p></FONT></FONT></SPAN></I></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-layout-grid-align: none"><I
style="mso-bidi-font-style: normal"><SPAN
style="FONT-SIZE: 9pt; mso-bidi-font-family: Arial"><o:p><FONT face=Arial
color=#000000> </FONT></o:p></SPAN></I></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><I
style="mso-bidi-font-style: normal"><SPAN lang=EN-GB
style="FONT-SIZE: 9pt; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB"><FONT
color=#000000><FONT face=Arial>This e-mail message and all attachments
transmitted with it are intended solely for the use of the addressee and may
contain legally privileged and confidential information. If the reader of this
message is not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified that
any dissemination, distribution, copying, or other use of this message or its
attachments is strictly prohibited. If you have received this message in error,
please notify the sender immediately by replying to this message and please
delete it from your computer.<o:p></o:p></FONT></FONT></SPAN></I></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB
style="FONT-SIZE: 9pt; mso-ansi-language: EN-GB"><o:p><FONT face=Arial
color=#000000> </FONT></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-GB
style="mso-ansi-language: EN-GB"><o:p><FONT face=Arial color=#000000
size=3> </FONT></o:p></SPAN></P>
<P align=center></FONT></FONT></P><PRE></PRE></BODY></HTML>