[Mondrian] InfoBright and UPPER in the WHERE clause

Sergey Mazin sergey.mazin at skype.net
Mon Jun 14 02:53:58 EDT 2010

Hi Donovan,

I think you need to add:

mondrian.olap.case.sensitive = true

to the mondrian.properties configuration file.

More information here:


-----Original Message-----
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Donovan Hide
Sent: Monday, June 14, 2010 9:47 AM
To: mondrian at pentaho.org
Subject: [Mondrian] InfoBright and UPPER in the WHERE clause


not sure if this mailing list is the correct place for this query, but
my forum acceptance hasn't come through yet!!

I'm using InfoBright with Mondrian and have a degenerate dimensions
defined thus:

                <Dimension name="Department">
                        <Hierarchy hasAll="true" allMemberName="All
                                <Level name="Department" type="String"
column="Department_code" nameColumn="Department_description"
captionColumnn="Department_description" uniqueMembers="false"/>

which generates this SQL:

select `Facts`.`Department_code` as `c0`,
`Facts`.`Department_description` as `c1` from `Facts` as `Facts` where
UPPER(`Facts`.`Department_description`) = UPPER('Charity Commission')
group by `c0`, `c1` order by `Facts`.`Department_code` ASC

Is there a way to prevent the UPPER statement being added? It kills
InfoBright's performance massively.

Mondrian mailing list
Mondrian at pentaho.org

More information about the Mondrian mailing list