[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