[Mondrian] Measure spanning across two rows in fact table

Saurabh Nanda saurabhnanda at gmail.com
Thu Aug 13 02:58:42 EDT 2009


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


More information about the Mondrian mailing list