<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>&nbsp;</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>&nbsp;</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.
&nbsp;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>&nbsp;</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 &nbsp;&#8216;qty&#8217; * &#8216;price&#8217; where
     &#8216;qty&#8217; and &#8216;price&#8217; 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&amp;highlight=fact+aggregator">http://forums.pentaho.org/showthread.php?t=47865&amp;highlight=fact+aggregator</a>
     , but would like an approach that didn&#8217;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
     &#8216;date&#8217; type for &#8216;type&#8217; 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. &nbsp;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>