<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
p.MsoToc1, li.MsoToc1, div.MsoToc1
        {margin-top:6.0pt;
        margin-right:0in;
        margin-bottom:6.0pt;
        margin-left:0in;
        font-size:12.0pt;
        font-family:Arial;
        text-transform:uppercase;
        font-weight:bold;}
p.MsoToc2, li.MsoToc2, div.MsoToc2
        {margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:12.0pt;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:Arial;
        font-variant:small-caps;}
p.MsoToc3, li.MsoToc3, div.MsoToc3
        {margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:24.0pt;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:Arial;}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle20
        {mso-style-type:personal;
        font-family:Arial;
        color:windowtext;}
span.EmailStyle21
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in .7in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
/* List Definitions */
@list l0
        {mso-list-id:415397990;
        mso-list-template-ids:1608933470;}
@list l1
        {mso-list-id:2065055004;
        mso-list-type:hybrid;
        mso-list-template-ids:1313232118 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
        {mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level2
        {mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level3
        {mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level4
        {mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level5
        {mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level6
        {mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level7
        {mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level8
        {mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l1:level9
        {mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<blockquote style='border:none;border-left:solid navy 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We have a few issues with mondrian while building a schema.
We searched on forums and documentation to look for answers. We would
like to confirm from you about the possible ways of resolving these issues.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='margin-bottom:12.0pt;mso-list:l1 level1 lfo3'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Calculations
on fact table columns<br>
<br>
Is it possible to perform calculations on fact table columns without
applying any aggregator on measure.<br>
Eg. We want to calculate the sale amount on each record in fact table
using the columns as ‘qty’ * ‘price’ where
‘qty’ and ‘price’ exist as columns in fact table.<br>
The problem is how do we specify this calculation in schema without using
an aggregator. We did see post on this at <a
href="http://forums.pentaho.org/showthread.php?t=47865&highlight=fact+aggregator">http://forums.pentaho.org/showthread.php?t=47865&highlight=fact+aggregator</a>
, but would like an approach that didn’t involve a code
modification.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l1 level1 lfo3'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>The mondrian 2.3.2 allows
‘date’ type for ‘type’ attribute in level. Is it
possible to apply date manipulations on such types. Eg. Finding date
differences between two member values of type date. We get 0 as result
value when we apply a difference of these values. This feature would
also be useful if we have to find difference between current date and a
date member.<br>
This query is also posted on forums as <a
href="http://forums.pentaho.org/showthread.php?t=54268">http://forums.pentaho.org/showthread.php?t=54268</a></span></font>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></li>
</ol>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.25in'><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Thanks and Regards<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.25in'><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Somita Arora<o:p></o:p></span></font></p>
</blockquote>
</div>
</body>
</html>