[Mondrian] FW: Aliases issue

Yury Bakhmutski Yury_Bakhmutski at epam.com
Tue Oct 6 10:57:34 EDT 2015

Hi, All!

I'm investigating http://jira.pentaho.com/browse/MONDRIAN-472 and found out strange behavior:

 {([Measures].[Store Cost],[Store].[All Stores].[USA].[OR])} on AXIS(0),
{ AGGREGATE(TOPCOUNT({[Product].[Product Name].MEMBERS}, 10, [Measures].[Unit Sales]))} on AXIS(1)
from [Sales]

throws an exception: ... Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{<Numeric Expression>}'


MEMBER [Product].[10 Top Unit Sales] AS
'AGGREGATE(TOPCOUNT({[Product].[Product Name].MEMBERS}, 10, [Measures].[Unit Sales]))'
 {([Measures].[Store Cost],[Store].[All Stores].[USA].[OR])} on AXIS(0),
{[Product].[10 Top Unit Sales]} on AXIS(1)
from [Sales]

is executed successfully.

Is it a bug?

Thanks, Yury.

Best Regards,
Yury Bakhmutski
Software Engineer

EPAM Systems http://www.epam.com<http://www.epam.com/>; Minsk office, Belarus; GMT+3
Mobile phone:       +375 (29) 564-20-14 (MTC)
E-mail:               yury_bakhmutski at epam.com<mailto:yury_bakhmutski at epam.com>

This message is intended only for the use of the individual(s) or entity(ies) to which it is addressed and contains information that is legally privileged and confidential. If you are not the intended recipient, or the person responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. All unintended recipients are obliged to delete this message and destroy any printed copies.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20151006/b0712488/attachment.html 

More information about the Mondrian mailing list