[Mondrian] Measure spanning across two rows in fact table

Saurabh Nanda saurabhnanda at gmail.com
Thu Aug 13 06:31:48 EDT 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090813/18883144/attachment.html 


More information about the Mondrian mailing list