[Mondrian] FW: [Mondrian-devel] Patch for mondrian [for TIME and TIMESTAMP measures]

Julian Hyde jhyde at pentaho.com
Sun Sep 7 16:27:57 EDT 2008


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
http://sourceforge.net/tracker/index.php?func=detail
<http://sourceforge.net/tracker/index.php?func=detail&aid=2099134&group_id=3
5302&atid=414613> &aid=2099134&group_id=35302&atid=414613 to fix the problem
properly.
 
Julian

  _____  

From: mondrian-devel-bounces at lists.sourceforge.net
[mailto:mondrian-devel-bounces at lists.sourceforge.net] On Behalf Of
Ruediger.Andrae at first-financial.biz
Sent: Thursday, November 08, 2007 5:59 AM
To: mondrian-devel at lists.sourceforge.net
Subject: [Mondrian-devel] Patch for mondrian


Hi,
I have a Patch for this problem:
 

 
TIME_JZ_VON ZP and TIME_ZP_BIS_ZP are java.sql.Timestamps. Method
processData crached for these type (near line 390).
 
 
 
Cube Definition is:
 
<!-- Cube zeigt CPU-Verbrauch und Laufzeiten pro Job bis auf Tagesebene, die
am Tag nur 1x laufen -->
<Cube name="JZ_Anteil2">
<View alias="V_ADM_JZJOB2">
<SQL dialect="generic">
<![CDATA[SELECT JZJOBX.JOB_NAME, JZJOBX.JOBZEIT_DAT,
JZJOBX.JOBZEIT_VON_ZP, JZJOBX.JOBZEIT_BIS_ZP,
TIME(JOBZEIT_VON_ZP) AS TIME_JZ_VON_ZP, 
TIME(JOBZEIT_BIS_ZP) AS TIME_JZ_BIS_ZP,
JZJOBX.LAUF_DAUER_MS AS LAUF_DAUER_MS, 
JZJOBX.CPU_DAUER_MS AS CPU_DAUER_MS,
JZJOBX.ANZ_STEPS, JZJOBX.SUM_EX_CP,
JZJOBX.COND_CODE, 1 AS ANZ_LAEUFE,
JZJOBX.DIM_JAHR, JZJOBX.DIM_MONAT,
JZJOBX.DIM_TAG
FROM ADM_JZJOB AS JZJOBX
JOIN ( SELECT JZJOB.JOB_NAME, 
JZJOB.DIM_JAHR, JZJOB.DIM_MONAT, JZJOB.DIM_TAG,
COUNT(*) AS ANZAHL
FROM ADM_JZJOB AS JZJOB
JOIN VAJOB_OLAP AS JOB
ON JZJOB.JOB_NAME = JOB.JOB_NAME
AND JOB.PRODSTATISTIK_KZ = 'J'
GROUP BY JZJOB.JOB_NAME, JZJOB.DIM_JAHR, JZJOB.DIM_MONAT, JZJOB.DIM_TAG
) AS VJZ_EINMALJOBS
ON VJZ_EINMALJOBS.JOB_NAME = JZJOBX.JOB_NAME
AND VJZ_EINMALJOBS.DIM_JAHR = JZJOBX.DIM_JAHR
AND VJZ_EINMALJOBS.DIM_MONAT = JZJOBX.DIM_MONAT
AND VJZ_EINMALJOBS.DIM_TAG = JZJOBX.DIM_TAG
WHERE VJZ_EINMALJOBS.ANZAHL=1]]>
</SQL>
</View>
<Dimension name="Job">
<Hierarchy hasAll="true" allMemberName="Alle Jobs" >
<Level name="Job" column="JOB_NAME" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Zeit">
<Hierarchy hasAll="true" allMemberName="Gesamt" >
<Level name="Jahr" column="DIM_JAHR" uniqueMembers="true"/>
<Level name="Monat" column="DIM_MONAT" uniqueMembers="true"/>
<Level name="Tag" column="DIM_TAG" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="CPU Dauer" column="CPU_DAUER_MS" caption="CPU-Verbrauch"
aggregator="sum" formatter="biz.ff.olap.DauerCellFormatter" />
<Measure name="LAUF Dauer" column="LAUF_DAUER_MS" caption="Laufzeit"
aggregator="sum" formatter="biz.ff.olap.DauerCellFormatter" />
<Measure name="Min Dauer" column="LAUF_DAUER_MS" caption="Min Dauer"
aggregator="min" formatter="biz.ff.olap.DauerCellFormatter" />
<Measure name="Mittlere Dauer" column="LAUF_DAUER_MS" caption="Mittlere
Dauer" aggregator="avg" formatter="biz.ff.olap.DauerCellFormatter" />
<Measure name="Max Dauer" column="LAUF_DAUER_MS" caption="Max Dauer"
aggregator="max" formatter="biz.ff.olap.DauerCellFormatter" />
<Measure name="Anzahl" column="ANZ_LAEUFE" caption="Anzahl Läufe"
aggregator="sum" formatString="#,##0"/>
<Measure name="Min Startzeit" column="TIME_JZ_VON_ZP" aggregator="min"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/>
<Measure name="Max Startzeit" column="TIME_JZ_VON_ZP" aggregator="max"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/>
<Measure name="Min Endezeit" column="TIME_JZ_BIS_ZP" aggregator="min"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/>
<Measure name="Max Endezeit" column="TIME_JZ_BIS_ZP" aggregator="max"
formatter="biz.ff.olap.ZeitpunktCellFormatter"/>
</Cube>
 
Aareal First Financial Solutions AG, Sitz der Gesellschaft: Wiesbaden 
Handelsregister: Amtsgericht Wiesbaden HRB 12775 
Aufsichtsratsvorsitzender: Thomas Ortmanns 
Vorstand: Georg Diehl 

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. 

 

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.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080907/9b48352f/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/bmp
Size: 302486 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080907/9b48352f/attachment.bmp 


More information about the Mondrian mailing list