[Mondrian] Measure spanning across two rows in fact table

Saurabh Nanda saurabhnanda at gmail.com
Thu Aug 13 06:34:19 EDT 2009

```The example for CalculatedMember given at
http://mondrian.pentaho.org/documentation/schema.php#Cubes_and_dimensions is
using quantities belonging to the same row. How do I reference two different
rows (with the same date) in the formula?

Saurabh.

On Thu, Aug 13, 2009 at 4:01 PM, Saurabh Nanda <saurabhnanda at gmail.com>wrote:

> Julian, are you referring to a CalculatedMember (
> http://mondrian.pentaho.org/documentation/xml_schema.php#CalculatedMember)?
> I couldn't find a CalculatedMeasure anywhere.
>
> Saurabh.
>
> On Thu, Aug 13, 2009 at 3:12 PM, Julian Hyde <jhyde at pentaho.com> wrote:
>
>>  You need a calculated measure.
>>
>>  ------------------------------
>> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
>> *On Behalf Of *Saurabh Nanda
>> *Sent:* Wednesday, August 12, 2009 11:59 PM
>> *To:* mondrian at pentaho.org
>> *Subject:* [Mondrian] Measure spanning across two rows in fact table
>>
>> Hi,
>>
>> 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:
>>
>> Fact table fomat: | Date | URL | Page views | Unique visitors | Session
>> count |
>> 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
>>
>> Thanks,
>> Saurabh.
>> --
>> http://nandz.blogspot.com
>> http://foodieforlife.blogspot.com
>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
>
> --
> http://nandz.blogspot.com
> http://foodieforlife.blogspot.com
>

--
http://nandz.blogspot.com
http://foodieforlife.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090813/e0327d0e/attachment.html
```