[Mondrian] Measure spanning across two rows in fact table

Nicholas Goodman ngoodman at bayontechnologies.com
Thu Aug 13 11:42:10 EDT 2009


On Aug 13, 2009, at 3:34 AM, Saurabh Nanda wrote:

> How do I reference two different rows (with the same date) in the  
> formula?


Saurabh,

Mondrian calculated members are inherently multi row because they are  
combinations of base and other calculated members (which are  
aggregated across many rows from the database).

In your case, your calculated member would look something like:

([Measures].[Unique Visitors], [URL].[<<url member name for your  
confirmation URL>>] / ([Measures].[Unique Vistors], [URL].[All URLs]

Nick



More information about the Mondrian mailing list