[Mondrian] Bug in SqlMemberSource.getMemberChildren ?

Pedro Alves pedro at neraka.no-ip.org
Fri Aug 15 23:45:50 EDT 2008



Hello everyone.


I found a very strange behaviour in SqlMemberSource.getMemberChildren.
Using the following query:

select NON EMPTY {Order(Filter(TopCount([Channels].[All].Children,
24,[Measures].[Total Requests]), [Channels].CurrentMember NOT IN {
[Channels].[All].[beta], [Channels].[All].[default],
[Channels].[All].[nightly], [Channels].[All].[release] })
,[Measures].[Total Requests],DESC )}  ON COLUMNS, {[Date].[All]} ON ROWS
from [AUS Analysis]


I see mondrian generating a log of this queries:


2008-08-16 04:36:13,427 DEBUG [mondrian.rolap.RolapUtil]
SqlMemberSource.getMemberChildren: executing sql [select 
 "aus_requests_by_day"."product_channel" as "c0"
from 
 "aus_requests_by_day" as "aus_requests_by_day"
where 
 "aus_requests_by_day"."product_channel" = 'nightly'
group by 
 "aus_requests_by_day"."product_channel"
order by 
 "aus_requests_by_day"."product_channel" ASC
], exec 1163 ms


This is a *very* big database, and it's obvious the result will be
'nightly'. What's the purpose of this? Channels is a one level dimension.


Am I doing something wrong? Thanks


Pedro



-- 
Pedro Alves
pmgalves-at-gmail.com




More information about the Mondrian mailing list