The example for CalculatedMember given at <a href="http://mondrian.pentaho.org/documentation/schema.php#Cubes_and_dimensions">http://mondrian.pentaho.org/documentation/schema.php#Cubes_and_dimensions</a> is using quantities belonging to the same row. How do I reference two different rows (with the same date) in the formula?<br>
<br>Saurabh.<br><br><div class="gmail_quote">On Thu, Aug 13, 2009 at 4:01 PM, Saurabh Nanda <span dir="ltr"><<a href="mailto:saurabhnanda@gmail.com">saurabhnanda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Julian, are you referring to a CalculatedMember (<a href="http://mondrian.pentaho.org/documentation/xml_schema.php#CalculatedMember" target="_blank">http://mondrian.pentaho.org/documentation/xml_schema.php#CalculatedMember</a>)? I couldn't find a CalculatedMeasure anywhere.<br>
<br>Saurabh.<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Thu, Aug 13, 2009 at 3:12 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
<div>
<div><span><font face="Lucida Sans" size="2" color="#000080">You need a calculated measure.</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Saurabh
Nanda<br><b>Sent:</b> Wednesday, August 12, 2009 11:59 PM<br><b>To:</b>
<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br><b>Subject:</b> [Mondrian] Measure spanning across two
rows in fact table<br></font><br></div><div><div></div><div>
<div></div>Hi,<br><br>I'm trying to define a measure whose value is computed
by taking quantities across two rows in the fact table. How do I do it? Here's
what I'm trying to do:<br><br>Fact table fomat: | Date | URL | Page views |
Unique visitors | Session count |<br>Required measure: Conversion for a given
date = number of unique visitors on confirmation URL (on that date) / number
of unique visitors on search URL (on that date) x
100<br><br>Thanks,<br>Saurabh.<br>-- <br><a href="http://nandz.blogspot.com" target="_blank">http://nandz.blogspot.com</a><br><a href="http://foodieforlife.blogspot.com" target="_blank">http://foodieforlife.blogspot.com</a><br>
</div></div></blockquote></div>
<br></div></div>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><div><div></div><div class="h5"><br><br clear="all"><br>-- <br><a href="http://nandz.blogspot.com" target="_blank">http://nandz.blogspot.com</a><br><a href="http://foodieforlife.blogspot.com" target="_blank">http://foodieforlife.blogspot.com</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://nandz.blogspot.com">http://nandz.blogspot.com</a><br><a href="http://foodieforlife.blogspot.com">http://foodieforlife.blogspot.com</a><br>