0

Mondrian seems to run a lot of groupby sqls before getting the aggregation results, such as

select
    `t`.`year` as `c0`
from
    `table` as `t`
where
    UPPER(`t`.`c0`) = UPPER('1997')
group by
    `t`.`c0`
order by
    ISNULL(`c0`) ASC, `c0` ASC

When the slicer includes a number of values, like {[Time].[1997],[Time].[1998],[Time].[1999]}, Mondrian will execute a groupby sql for each of the values.

My mdx contains hundreds of values in one dimension, so it often costs too much on executing these sqls. Even retrieved from cache, they are still executed while querying the cache with the values directly seems more reasonable. There anyone knows the reason? Thanks a lot.

New contributor
Sasaki Gao is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

Sasaki Gao is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.