[Mondrian] CM performance
Paul Stoellberger
p.stoellberger at gmail.com
Fri Jun 15 13:22:51 EDT 2012
Hi,
I have a query that looks like that:
with
member Measures.P as Measures.Sales / Measures.Quantity
member Measures.[Price Range] as
IIF( Measures.P is null, null,
IIF( Measures.P < 0.3 AND Measures.P < 0.5, '< 0.30',
IIF( Measures.P >= 0.3 AND Measures.P < 0.5, '0.30-0.49',
IIF( Measures.P >= 0.5 AND Measures.P < 0.8, '0.50-0.79',
null
))))
select { Measurse.Sales, Measures. Quantity, Measures.[Price Range] } ON COLUMNS,
{ Skus.Skuname.Members } ON ROWS
from [Sales]
now my problem is that mondrian executes a query for each IF statement (or at least execution time increases along with the number of if statements)
is there any better way to do that? why isn't mondrian calculating P and then just running through the if?
-Paul
More information about the Mondrian
mailing list