[Mondrian] InfoBright and UPPER in the WHERE clause

[Sergey Mazin]

Hi Donovan,

I think you need to add:

mondrian.olap.case.sensitive = true

to the mondrian.properties configuration file.

More information here:
http://mondrian.pentaho.org/documentation/configuration.php#Properties

Regards,
Sergey

-----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

Hi,

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
Departments">
                                <Level name="Department" type="String"
column="Department_code" nameColumn="Department_description"
captionColumnn="Department_description" uniqueMembers="false"/>
                        </Hierarchy>
                </Dimension>

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.

Cheers,
Donovan.
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian