[Mondrian] InfoBright and UPPER in the WHERE clause

[Donovan Hide]

Hi Sergey,

thanks for the reply! Currently I have:

# Allow the use of aggregates
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.native.topcount.enable=true
mondrian.native.filter.enable=true
mondrian.olap.case.sensitive=true

# mondrian.properties
mondrian.result.limit=50000

here:

/opt/tomcat6/webapps/mondrian/WEB-INF/mondrian.properties

and I still get the UPPER statements in the WHERE clause. Is
mondrian.properties in the right place?

Cheers,
Donovan.


On 14 June 2010 07:53, Sergey Mazin <sergey.mazin at skype.net> wrote:
> 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
>