[Mondrian] Wrong result for TopCount using calculated measure

Pedro Salgueiro pedro.salgueiro at inductiva.pt
Wed Dec 26 10:15:28 EST 2012


This could be related to this issue:

http://jira.pentaho.com/browse/MONDRIAN-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Cheers,
Pedro


On Tue, Dec 25, 2012 at 5:12 AM, m.xinu <mehdi_xinu at yahoo.com> wrote:

> I checked it in Mondrian "3.3.0.14703", "3.4.1" and "3.5.0". The results
> all are the same.
>
>
>   ------------------------------
> *From:* Kurtis Walker <kwalker at pentaho.com>
> *To:* mondrian at pentaho.org; m. xinu <mehdi_xinu at yahoo.com>
> *Sent:* Monday, December 24, 2012 4:37 PM
> *Subject:* Re: [Mondrian] Wrong result for TopCount using calculated
> measure
>
>  Seems like a bug to me. What version of mondrian are you using?
>
> On Monday, December 24, 2012 10:24:32 AM m. xinu wrote:
> Hi,
>
> I defined a calculated member in [Measures] dimension, and when I execute
> the following MDX:
>
> select TopCount([ExpireDate].[Month].Members, 10,
> [Measures].[TotalAmount]) ON COLUMNS,
>   [Measures].[TotalAmount] ON ROWS
> from [Deposit]
>
> the result is wrong, but when I use Order() function instead of TopCount,
> the result is OK. In fact the following MDX works fine:
>
> select Head(Order([ExpireDate].[Month].Members, [Measures].[TotalAmount],
> DESC), 10) ON COLUMNS,
>   [Measures].[TotalAmount] ON ROWS
> from [Deposit]
>
> The [Measures].[TotalAmount] is a calculated member defined in Mondrian
> schema as follows:
>
> <CalculatedMember name="TotalAmount" dimension="Measures">
> <Formula>
> [Measures].[MainAccAmount] + [Measures].[IntblockedAccAmount] +
> [Measures].[BlockedAccAmount]
> </Formula>
> </CalculatedMember>
>
> Is it a bug? or did I use something wrong?
>
>
>
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121226/25bd89d6/attachment.html 


More information about the Mondrian mailing list