[Mondrian] InfoBright and UPPER in the WHERE clause
sergey.mazin at skype.net
Mon Jun 14 02:53:58 EDT 2010
I think you need to add:
mondrian.olap.case.sensitive = true
to the mondrian.properties configuration file.
More information here:
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
<Hierarchy hasAll="true" allMemberName="All
<Level name="Department" type="String"
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